How to change date format in QV Edit script?

[Anonymous]

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

[#2]

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.

[its_anandrjs]

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

[#4]

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

[Anonymous]

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

[#6]

Hi Shubham,

Good to hear.!

KR Gert jan