topic Date Format in QlikView

Date Format

Thu, 13 Mar 2014 20:52:10 GMT

Hi,

I have a date format as "Apr 2 2011 12:00 AM", how can I convert this into "YYYYMMDD"? The time is always12:00 AM.

Thanks.

Re: Date Format

maxgro — Thu, 13 Mar 2014 21:09:22 GMT

= date(

date#('Apr 2 2011 12:00 AM', 'MMM DD YYYY hh:mm TT'), 'YYYYMMDD'

)

look at this for date and date# functions

QlikView Date fields

EDIT

see attachment

Re: Date Format

vidyut — Thu, 13 Mar 2014 21:10:05 GMT

Makedate(Subfield(DateString,' ',3),Div(Index($(MonthNames),Subfield(DateString,' ',1)),4)+1,Subfield(DateString,' ',2)) as Date

Try this. $(MonthNames) refers to the variable MonthNames defined by default in your script.

Cheers,

Vidyut

Re: Date Format

Thu, 13 Mar 2014 21:24:13 GMT

You are close,

Can you please help identify the error in this code

(Subfield([Fiscal Week Ending Date],' ',3),Div(Index($(MonthNames),Subfield([Fiscal Week Ending Date],' ',1),4)+1,Subfield([Fiscal Week Ending Date],' ',2))) as Date

[Fiscal Week Ending Date], is my date variable and seems like ')' is missing.

Re: Date Format

Thu, 13 Mar 2014 21:24:59 GMT

I tried this. not working