Timestamp format help

[vvvvvvizard]

Attaches is the excel sheet with the timestamp

Am trying to create a field that displays the timestamp , it must appear in charts and graphs as DD/MM/YYYYY hh:mm:ss tt format (not the number format )

another field which just shows DD/MM/YYYY hh:mm only (floor  get the minutes , 9:45:35 , 9:45:12 must both show as 9:45)

one that shows the Hour only , so 9:00 , 10:00 : 11:00 14:00 ect (floor to get the hour  , so 9:01 9:54 must show as 9:00

one that shows the DD/MM/YYYY only

[SatyaPaleti]

Hi Yousuf,

Look into following link

Alt function

This Might helpful

Thank you,

SatyaPaleti

[sunny_talwar]

This?

Script:

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/DD/YYYY';

SET TimestampFormat='M/DD/YYYY h:mm:ss[.fff] TT';

Table:

LOAD Timestamp,

  Time(Frac(Timestamp)) as Time,

  Date(Floor(Timestamp)) as Date

FROM

Community_174113.xlsx

(ooxml, embedded labels, table is Sheet1);

[PrashantSangle]

Hi,

use Date()

try like

1) Date(YourField,'DD/MM/YYYY hh:mm:ss')

2) Date(YourField,'DD/MM/YYYY hh:mm')

3) Hour(YourField)

4) Date(YourField,'DD/MM/YYYY')

Regards

[sunny_talwar · Accepted solution]

Or this:

Script:

Table:

LOAD Timestamp,

  TimeStamp(Timestamp, 'DD/MM/YYYY hh:mm') as Timestamp1,

  Time(Time#(Floor(Frac(Timestamp) * 60 * 60/150), 'hh'), 'hh:mm') as Time,

  Date(Floor(Timestamp), 'DD/MM/YYYY') as Date

FROM

Community_174113.xlsx

(ooxml, embedded labels, table is Sheet1);