Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to convert this field to date format MM/DD/YYYY?

fb_date.png

convert created_time to floor date format?

5 Replies
satishkurra
Specialist II
Specialist II

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

sunny_talwar

How many times did you ask the same question . Try not to duplicate the same thread

Not applicable
Author

Sorry

Chanty4u
MVP
MVP

Please cclose this thread by marking correct or helpful answers.

HirisH_V7
Master
Master

Hi,

Check with this,

Date(Date#(SubField(created_time,'T',1),'YYYY-MM-DD'),'MM/DD/YYYY') as Date

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”