Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Date Format

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

2 Replies
Apache
New Contributor III

Re: Date Format

Hi Holguin,

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

Re: Date Format

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