Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have requirement to get Time only from DateTime field which has values in format M/DD/YYYY hh:mm:ss TT
How to achieve it?
May be this
Time(Frac(DateTimeFieldName)) as Time
It gives me integer number . I have used subfield function to get time part.
My next step is to join it to DimTime which has hour column of type varchar 12:00 AM/PM.
How to make join work
I added Time(Frac(DateTime),'h:mmTT') as TimeSk in Fact. Now when i join it with DimTime TimeSk,
I am getting wrong bargraph as attached
Any help appreciated
Difficult to know without a sample file to look at