topic Re: Date in QlikView

Date

NavinReddy — Tue, 06 Aug 2013 04:23:34 GMT

Hi All,

My dates should be like this format

how can i change format like(DD/MM/YYYY)

i tried Date# its not working for me

some one help me

plz find the attachment

thanks in advance,

rohith

Re: Date

MayilVahanan — Tue, 06 Aug 2013 04:32:50 GMT

Try like this

= Date(Date#(DateField, 'YYYYMMDD'),'DD/MM/YYYY')

If its already in date format.

= Date(Date(DateField, 'YYYYMMDD'),'DD/MM/YYYY')

Hope that helps

Re: Date

Anonymous — Tue, 06 Aug 2013 04:42:47 GMT

use the set command to set the date format and then try to use the date functions

SET DateFormat='YYYYMMDD';

once this format is set the data in the above format can be used in date function.

Re: Date

NavinReddy — Tue, 06 Aug 2013 04:44:26 GMT

Hi All,

Not working for both expressions

Thanks,

rohith

Re: Date

MayilVahanan — Tue, 06 Aug 2013 04:50:35 GMT

Is it.. Can u post a sample file

Re: Date

NavinReddy — Tue, 06 Aug 2013 05:24:05 GMT

Hi All,

Load

Date(Date#([Dat ],'YYYYMMDD'),'DD/MM/YYYY') as [Date]

Resident Date;

DROP Tables Date;

Im using these script to change format

Plz find the attachment like the way i m getting

some one help me

thanks in advance,

rohith

Re: Date

tresB — Tue, 06 Aug 2013 05:35:01 GMT

Rohith,

It seems that your [Date Key] is a key field and present there in multiple tables. If it is so, i would suggest you to set your date format at the beginning of your script like:

Set DateFornat='DD/MM/YYYY'

that would be the easiest option to change the date format instead fo changing all of them in different tables. Otherwise, you can do it specifically at the front end as well. In a list box, select expression and there you write

=Date([Date Key] , 'DD/MM/YYYY')

Re: Date

NavinReddy — Tue, 06 Aug 2013 05:47:12 GMT

Hi All,

Set [Date]='DD/MM/YYYY'

Date([Date] , 'DD/MM/YYYY') in list box im using same expression

again im facing same issue

thanks in advance,

rohith

Re: Date

NavinReddy — Tue, 06 Aug 2013 06:42:46 GMT

hi vishwa,

sorry im not getting now also

Thanks,

rohiht

Re: Date

priyav24 — Tue, 06 Aug 2013 07:18:33 GMT

Hi Rohit,

Try this go to Settings -> Document Properties ->Number

Select the field in the left side and choose the format you want as show in the figure..

Regards,

Priya

Re: Date

NavinReddy — Tue, 06 Aug 2013 08:20:53 GMT

Thank you priya

working fine