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: 
Not applicable

convert to date format YYYY/MM/DD?

Date(Date#(Subfield(created_time,'-',1) &'/'& Subfield(created_time,'-',2) &'/'& Subfield(created_time,'T',3) ,'YYYY/MM/DD'),'YYYY/MM/DD')as [newdate],

This is not working.

fb_date.png

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD') as NewDate

View solution in original post

4 Replies
sunny_talwar

May be this:

Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD') as NewDate

Gysbert_Wassenaar

Maybe like this:

Date(Floor(Timestamp#(created_time, 'YYYY-MM-DDThh:mm:ss+ffff')),'YYYY/MM/DD')

If not, please post a source data file.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you

Not applicable
Author

Thank you