topic How to convert date format in QlikView

How to convert date format

Mon, 14 Apr 2014 04:37:42 GMT

how to convert

20131022005811 to 22/10/2013

Re: How to convert date format

tresB — Mon, 14 Apr 2014 04:40:25 GMT

Try like:

Date(Date#('20131022005811' , 'YYYYMMDDhhmmss') , 'DD/MM/YYYY')

Now you can replace your value with field name as well.

Re: How to convert date format

Mon, 14 Apr 2014 04:58:21 GMT

its not working..

i have a date field in this format(YYYYMMDDhhmmss)and i want to map this to calender function i'm using in which date is in format of DD/MM/YYYY.

Re: How to convert date format

tresB — Mon, 14 Apr 2014 05:00:44 GMT

How are you writing the code?

Re: How to convert date format

nizamsha — Mon, 14 Apr 2014 05:01:33 GMT

Date( Date#('YourField','YYYYMMDDhhMMss'),'DD/MM/YYYY')

Before u give Date format check what format its already defined in set format

Re: How to convert date format

Mon, 14 Apr 2014 05:05:35 GMT

Date( Date#('CDAT','YYYYMMDDhhMMss'),'DD/MM/YYYY')as Date,

Re: How to convert date format

Mon, 14 Apr 2014 05:06:43 GMT

in set format format defined is SET DateFormat='M/D/YYYY';

Re: How to convert date format

Mon, 14 Apr 2014 05:10:23 GMT

Use this

Date(Date#(CDAT,'YYYYMMDDhhmmss'),'DD/MM/YYYY') as Date

Re: How to convert date format

nizamsha — Mon, 14 Apr 2014 05:11:46 GMT

in set format change the date format MM/DD/YYYY and use this

Date( Date#(YourField,'YYYYMMDDhhMMss'),'DD/MM/YYYY')

Re: How to convert date format

Mon, 14 Apr 2014 05:15:24 GMT

this function is not working

i think this can be the problem dat i have defined date in calender function as dd/mm/yyyy and in defult set format this is M/D/YYYY'

Re: How to convert date format

tresB — Mon, 14 Apr 2014 05:17:49 GMT

Remove quotes around field name, it should work.

Date( Date#( CDAT ,'YYYYMMDDhhMMss'),'DD/MM/YYYY') as Date,

Re: How to convert date format

Mon, 14 Apr 2014 05:17:50 GMT

its not working

Re: How to convert date format

Mon, 14 Apr 2014 05:19:50 GMT

i have done each possible thing

Re: How to convert date format

tresB — Mon, 14 Apr 2014 05:21:08 GMT

Could you share your sample qvw with sample data?

Re: How to convert date format

Mon, 14 Apr 2014 05:22:26 GMT

Date#(Left(CDAT,2) & '/' & mid(CDAT,4,2) & '/' & mid(CDAT,7,4),'DD/MM/YYYY') as Date,

wat this function will do ?

Re: How to convert date format

tresB — Mon, 14 Apr 2014 05:29:30 GMT

This will try to do things in a complex way that Date#() alone can do in a simpler way. .

Re: How to convert date format

Mon, 14 Apr 2014 05:34:56 GMT

Hi,

Check these in Text objects

=Date(Date#('20131022005811' ,'YYYYMMDDhhmmss'),'DD/MM/YYYY')

=Date(Date#(Left('20131022005811',8),'YYYYMMDD'),'DD/MM/YYYY')

If works then use as is in script by replacing with your field without single quotes.

Re: How to convert date format

er_mohit — Mon, 14 Apr 2014 05:49:02 GMT

Try this in text object

Date(Date#('20131022005811','YYYYMMDDf'),'DD/MM/YYYY')

then in your script side

Re: How to convert date format

Mon, 14 Apr 2014 05:57:02 GMT

Thanku so much