Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Highlighted
satishkurra
Valued Contributor II

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

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

Highlighted

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

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

Highlighted
Not applicable

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

Sorry

Highlighted
Chanty4u
Esteemed Contributor III

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

Please cclose this thread by marking correct or helpful answers.

Highlighted
HirisH_V7
Honored Contributor

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

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!”