topic Re: Date format for all in QlikView

Date format for all

prma7799 — Wed, 21 Jan 2015 05:03:13 GMT

Hi All,

I have various date format like INVC_DT =DD-MM-YYYY

HIRE_DT=MM/DD/YYYY

BL_BT_DT=MM.YYYY.DD

AND SO ON................

So I my user want only one date format like DD/MM/YYYY

is there any way to get above format for all

Thanks

Prashant

Re: Date format for all

deepakqlikview_123 — Wed, 21 Jan 2015 05:16:49 GMT

Sample Script:

FinalTable:

Load

MyDateField

,DATE(ALT(Date#(MyDateField,’DD/MM/YYYY’)

,Date#(MyDateField,’MMM/DD/YYYY’)

,Date#(MyDateField,’DD/MMM/YYYY’))) AS MyFieldInDateFormat

Resident TablenAME;

Re: Date format for all

jagan — Wed, 21 Jan 2015 05:44:37 GMT

Hi,

In script convert all dates to single format

LOAD

Date(Date#(INVC_DT, 'DD-MM-YYYY'), 'DD/MM/YYYY') AS INVC_DT_FORMATTED,

Date(Date#(HIRE_DT, 'MM/DD/YYYY'), 'DD/MM/YYYY') AS HIRE_DT,_FOMATTED,

Date(Date#(BL_BT_DT, 'MM.YYYY.DD'), 'DD/MM/YYYY') AS BL_BT_DT_FORMATTED

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Date format for all

ashfaq_haseeb — Wed, 21 Jan 2015 06:10:45 GMT

Hi,

You need to look at alt function in case if it is through 1 field. For multiple fields you can convert then at script as suggested by Jagan.

Which conditional functions do you use?

Regards

ASHFAQ

Re: Date format for all

prma7799 — Wed, 21 Jan 2015 06:30:07 GMT

Thanks Jagan... but I am unable to see Latest QlikView Discussions.

Re: Date format for all

jagan — Wed, 21 Jan 2015 06:53:27 GMT

Hi,

I think there is some issue, you can use below link to see latest QV discussions.

Regards,

jagan.

Re: Date format for all

jagan — Wed, 21 Jan 2015 06:53:36 GMT

http://community.qlik.com/community/qlikview