topic Re: Date Format Issue in QlikView

Date Format Issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have a small doubt about Date Format

I am having Field with name Start Date and it is in Date in format of '2011/01/15 00:00:00'

I want to convert this in to MM/DD/YYYY Format I have used Date(floor([Start Date])) and also

Date([Start Date],'MM/DD/YYYY') But it showing null value . It should be Like 01/15/2011

Please Help me with this Issue

Thank you,

Swarup

trdandamudi — Wed, 27 Apr 2016 15:36:07 GMT

May be like this...

Date(Floor([Start Date]),'MM/DD/YYYY')

sunny_talwar — Wed, 27 Apr 2016 15:40:47 GMT

May be this:

Date(Floor(Date#(DateField, 'YYYY/MM/DD hh:mm:ss')), 'MM/DD/YYYY) as DateField

Date(Floor(Date#(Left(DateField, 10), 'YYYY/MM/DD')), 'MM/DD/YYYY) as DateField