Convert Timestamp to Date

[#1]

Hello Community,

I have a Timestamp date For example (2012-03-29 11:35:24.6270000 +00:00), I need to get the Date from this i.e 2012-03-29.

Please find the sample file.

I want it using Date functions only.

Note: I tried below expressions, but dint work.

date(floor(CompleteWorkflowDate))

Thanks,

Angad

[Sokkorn]

Hi Angad,

How about this one =Left(CompleteWorkflowDate,10)

Regards,

Sokkorn

[Sokkorn · Accepted solution]

Or try with this long function

=Date(Floor(Date#(CompleteWorkflowDate,'YYYY-MM-DD hh:mm:ss.fffffff +ff:ff')))

Regards,

Sokkorn

[#4]

BINGO!

Thanks a lot Sokkorn. I was not aware about those extra fffff's .

Thanks,

Angad

[#5]

I found this answer very helpful in solving my own problem.

I had a CSV file loaded and needed to convert it's many timestamp fields into a date.

Here is my slightly different code:

Date(floor(NUM(Timestamp#([FIELD NAME], 'DDMMMYYYY:hh:mm:ss')))) AS [NEW FIELD NAME],

Thanks,

Paul

[#6]

Thanks for sharing Paul. I am happy that it was helpful to you as well

Thanks,

Angad