Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Contributor III
Contributor III

Hi Holguin,

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

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