topic QS-Date Fields in App Development

QS-Date Fields

Karahs — Fri, 13 May 2016 12:09:50 GMT

Hello everyone,

I have date fields like this: May 12 2016 10:46AM

I want it in DD/MM/YYYY format and also want the timestamp.

How can i do that?

Thanks & Regards,

Kshitija

Chanty4u — Fri, 13 May 2016 12:12:20 GMT

load *,

Date(Date#(Datefiled,' MMM DD YYYY hh:mm TT'),'DD/MM/YYYY') AS newdate ;

Date(Date#(Datefiled,' May 12 2016 10:46AM'),'DD/MM/YYYY') AS newdate ;

Edited:

fashid — Fri, 13 May 2016 12:12:28 GMT

Try the date# and the date function

sunny_talwar — Fri, 13 May 2016 12:23:41 GMT

Try like this:

Date(Floor(Date#(DateField, 'MMM DD YYYY hh:mmTT'), 'DD/MM/YYYY') as Date,

Time(Frac(Date#(DateField, 'MMM DD YYYY hh:mmTT')) as Time,

Karahs — Mon, 16 May 2016 04:24:07 GMT

Hello,

So here is the format pf the date i have and i want to calculate TAT of this....

Karahs — Mon, 16 May 2016 07:36:17 GMT

Hello ,

I tried theb formula but its coming blank...

sunny_talwar — Mon, 16 May 2016 09:39:06 GMT

I think I missed some parenthesis, can you try this:

Date(Floor(Date#(DateField, 'MMM DD YYYY hh:mmTT')), 'DD/MM/YYYY') as Date,

Time(Frac(Date#(DateField, 'MMM DD YYYY hh:mmTT'))) as Time,

Karahs — Mon, 16 May 2016 10:53:07 GMT

Hello Sunny,

It worked thankyou. Can you also suggest how to calculate TAT(turn around time) ?? ie. difference between the review and entry date??

sunny_talwar — Mon, 16 May 2016 11:06:03 GMT

May be like this:

LOAD Interval([REVIEW DATE] - [ENTRY DATE]) as TAT

LOAD [ENTRY DATE],

Date(Floor(Date#([REVIEW DATE], 'MMM DD YYYY hh:mmTT')), 'DD/MM/YYYY') as [REVIEW DATE],

Time(Frac(Date#([REVIEW DATE], 'MMM DD YYYY hh:mmTT'))) as [REVIEW Time]

From Source;