topic Date Format in QlikView

Date Format

Thu, 13 Mar 2014 20:51:42 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

its_anandrjs — Thu, 13 Mar 2014 21:07:14 GMT

Hi,

Convert your date field like

Date(DateField,'YYYYMMDD')

Thanks & Regards

Re: Date Format

Thu, 13 Mar 2014 21:09:27 GMT

This will not work. It has something to do with timestamp.

Re: Date Format

its_anandrjs — Thu, 13 Mar 2014 21:16:57 GMT

Hi,

You mean to say when date change as YYYYMMDD the time should always 12:00 AM or also check your current date field it is date format or not.

Thanks & Regards

Re: Date Format

Thu, 13 Mar 2014 21:27:15 GMT

I want to change my current date field in YYYYMMDD format. With date function it will not work.

Re: Date Format

its_anandrjs — Thu, 13 Mar 2014 21:30:31 GMT

Hi,

Ok write some thing like this

Date(DateField,'YYYYMMDD h:mm:ss TT')

Hope this helps

Thanks & Regards

Re: Date Format

Josh_Good — Thu, 13 Mar 2014 21:31:15 GMT

You can go into Setting -> Document Properties and select the "Number" tab. From there you can set the field to be in the date format you desire and it will be change for the entire app.

Re: Date Format

Colin-Albert — Thu, 13 Mar 2014 21:32:56 GMT

Try

Date(date#(YourDateField, 'MMM D YYYY hh:mm') , 'YYYYMMDD hh:mm')

Re: Date Format

cgdonders — Thu, 13 Mar 2014 21:34:07 GMT

Hi,

If you only want to use the date you can delete the time (hh:mm:ss) by using the floor() function: DATE(FLOOR(datefield), 'YYYYMMDD').

Re: Date Format

Thu, 13 Mar 2014 21:46:30 GMT

To everyone, I tried all the options and attaching a sample excel.

Re: Re: Date Format

maxgro — Thu, 13 Mar 2014 21:50:36 GMT

see attachment

Re: Date Format

its_anandrjs — Thu, 13 Mar 2014 21:56:02 GMT

Hi,

Write some thing like

load *,

date( date#([Fiscal Week Ending Date], 'MMM DD YYYY hh:mmTT'), 'YYYYMMDD h:mm:ss TT' );

LOAD [Fiscal Week Ending Date],

FormattedDate

FROM your location

Thanks & Regards

Re: Date Format

Thu, 13 Mar 2014 22:01:20 GMT

This works for two digit 'DD". If you scroll down your QVW , you will see result has not populated for one digit day.

Re: Date Format

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

if you have different format, use the alt function

date(

alt(

date#([Fiscal Week Ending Date], 'MMM DD YYYY hh:mmTT'),

date#([Fiscal Week Ending Date], 'MMM D YYYY hh:mmTT')

)

, 'YYYYMMDD' )

Re: Date Format

Thu, 13 Mar 2014 22:16:37 GMT

Awesome