How do I convert a text timestamp to another field during data loading?

[wuming79]

Hi,

I have a field that is in the following format. 

YYYY-MM-DD HH:MM:SS

Is it possible to load this field to the following format. 

YYYY/MM/DD HH:MM:SS AM or YYYY/MM/DD HH:MM:SS PM

[seangordonsa · Accepted solution]

Hi

You can use the "timestamp#" function and then format the time as you need.

timestamp(timestamp#(DateField,'YYYY-MM-DD HH:mm:ss'),'YYYY/MM/DD hh:mm:ss tt')

Please give this a try.

Regards,

[jonathandienst · Accepted solution]

This should do it:

Date(Date#(myDateField, 'YYYY-MM-DD hh:mm:ss'), 'YYYY-MM-DD hh:mm:ss tt')

[wuming79]

Thanks Guys, Date(Date#(myDateField, 'YYYY-MM-DD hh:mm:ss'), 'YYYY/MM/DD hh:mm:ss tt') did the job!