Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register 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