Changing hour/date format

[Anonymous]

Hello, I have this Time/Date cell:

I want to separate the date and the hour from the cell,

how can I do that using the script?

Thank you very much

[#2 · Accepted solution]

Hi Juan,

you can do that using 3 functions: Date, Time, Floor

Date(floor(DateTimeField)) as [DateTimeField - Date],
Time(DateTimeField-floor(DateTimeField)) as [DateTimeField - Hour],

See the attached sample qvw.

Ingo.

[Sokkorn]

Hi Juan,

Try this simple

LOAD

DATE(DateField)    AS [Dates],

TIME(DateField)    AS [Times],

.....

FROM ....

Regards,

Sokkorn Cheav

[jagan]

Hi,

You can get the Date and Time in separate fields in in Load Script as suggested by Sokkorn by using DATE() and TIME() methods instead of Calculated dimension.  Calculated Dimensions leads to performance issues.

Hope this helps you.

Regards,

Jagan.