topic Re: Date format Problem in Qv Scripting? in QlikView

Date format Problem in Qv Scripting?

khasimvali85 — Mon, 13 Oct 2014 03:41:03 GMT

Hi Community,

Can anybody give the solution for the given date format?

i have the date field like give below, i wanna show format(DD/MM/YYYY)

Date:

--------------

2014.05.09

2014.05.10

2014.05.11

2014.05.12

2014.05.13

I given date function like Date(Date_field,'DD/MM/YYYY') as Date_field

but its not working any solution for this?

Regards,

Khasim.

Mon, 13 Oct 2014 03:56:23 GMT

Dear Khasim,

Use the following function in Script:-

date(date#(Date_field,'YYYY.MM.DD'),'DD/MM/YYYY') as Date_field

Thanks & Regards

Prince Anand

khasimvali85 — Mon, 13 Oct 2014 04:56:05 GMT

Dear Prince,

Its working fine Thanks for Suggest.

Regards,

Khasim.

Mon, 13 Oct 2014 08:27:14 GMT

Welcome