Date Format

[Anonymous]

Hi

I´m getting the next date format and I need to convert it into a "yyyy/mm/dd/ format, can someone can give me a hand?

Text: 1551801680000+0100

Form of the Api: 2019-04-22T15:29:01.6732911Z

Need: YYYY/MM/DD

Regards

[Apache]

Hi Holguin,

Just try this...
Date(Fieldname,'DD/MM/YYYY h:mm:ss[.fff] TT'),'YYYY/MM/DD'

[Apache]

May be this

Date(MonthStart(NewDate), 'YYYY/MM/DD') as YearMonth

or

Date(MonthStart(Date#(NewDate, 'DD-MM-YYYY hh:mm')), 'YYYY/MM/DD') as YearMonth

Thanks,

Apache