topic How to change date format in QV Edit script? in QlikView

How to change date format in QV Edit script?

Anonymous — Thu, 25 Aug 2011 08:56:06 GMT

We have older load from sql and now we are optimizing in QVD. but the date is not coming in right format. Any advise.

Best Regards

Shubham Kumar

How to change date format in QV Edit script?

Thu, 25 Aug 2011 10:10:38 GMT

Hi Shubham,

Am not sure whether I understood your question. If you want to change dates from the format, you can use for example Date(argument [, formatcode]), where format can be 'yy-mm-dd' or 'dd.mm.yy' etc.

Hope it helps

Greetz Gert Jan.

How to change date format in QV Edit script?

its_anandrjs — Thu, 25 Aug 2011 10:14:24 GMT

Hi,

I want to know from your end right now what format you are get when you load from qvd if you not get correct date fromat so change with this Date(Datefield,'MM/DD/YYYY')

Regards

Anand

How to change date format in QV Edit script?

Thu, 25 Aug 2011 11:24:15 GMT

Hi,

I just loaded a datefield and storerd it into a QVD and then loaded it from the QVD again. Without any formating it works just fine. The fields contain exactly the same values. When I use the formatting in my script I get also the expected result. Maybe you can send an example what goes wrong in your case?

Kind regards,

Gert Jan

How to change date format in QV Edit script?

Anonymous — Thu, 25 Aug 2011 11:29:01 GMT

Hi,

thanks for the reply. Sorry there was a mistake in my side. the field name was mismatch so that date was not coming but now its working fine.

Thanks

Shubham Kumar

How to change date format in QV Edit script?

Thu, 25 Aug 2011 11:30:13 GMT

Hi Shubham,

Good to hear.!

KR Gert jan