Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Data set which has "Time" as "17-SEP-12 01.08.47.530179000 AM"
So i need to divide taht time to,
Year
Month
Day
Hours
minutes
Please help.
At least tell me how to devide it in to Year,Month,Day
Thanks
A second small error in Jonathans answer: The Load should start with "Load *, Month(" instead of "Load Month("
HIC
Thanks All for your Help,
I have used Jonathan Dienst Code for load the time,
Then I have load my other data as a seperate table, then join those two tables.
It works
Thanks Everyone for your kind support
Hi
I have corrected for the otyher issue that Henric spotted. This means that you could load all the data in a single pass, rather than loading separatly and joining.
Regards
Jonathan
Hi,
I am trying to create a chart to display amount of cases occurring in each time of the day (such as 13.00 - 3 cases)
I have a calendar. I would like to add Hour as another field to my calendar. So just like I see the # of cases for lets say month period, I would like to see them in hour period. By this way I will have an idea about the hours in which cases are most and less..
I've tried to do this without changing the script using this calculated dimension " Time([Case Open Time], 'hh') " , but it displayed the hours for every date entry..(e.g. 12 12 12 13 13 14 14 14 14).
In either way how can I achieve implementing this ?
Hi,
Hour function resolved this issue.
Thanks.
is your > (Date) < in your script a QV function or the designated field that needs to be inserted into that spot?
Thanks
It is a field defined in the following Load statement:
LOAD *,
Month(Date) As Month,
Year(Date) As Year,
Day(Date) as Day,
Hour(Date) As Hour,
Minute(Date) As Minute;
LOAD Date(Date#(TIME, 'DD-MMM-YY hh.mm.ss.fffffffff tt')) As Date,
MACHINE_NAME, ...
See more on Preceding Load
HIC
Hi!
Maybe someone could help me to solve one problem.
Time format, which comes from one report is dd.mm.yy hh:mm:ss (there is space before dd), what i should get is dd.mm.yyyy, maybe anyone could help with this?
At moment tried use those 2 formulas :
Date(Date#( Datums,'DD.MM.YYYY')) as add_date,
Date(Floor(TimeStamp#(Datums,'DD/MM/YY hh:mm:ss')),'DD/MM/YYYY') as add_date,
Bouth formulas returns "-".
This is old post, Please start google before post an new thread? BTW, May be try
Date(Floor(TimeStamp#(Datums,'DD.MM.YY hh:mm:ss')),'DD/MM/YYYY') as add_date,