topic Re: Stardardize the date format in QlikView

Stardardize the date format

Black_Hole — Sat, 16 Nov 2024 20:01:20 GMT

Hello all,

I have a column for the field date.

In this column, there is two types of format YYYY/MM/DD and DD/MM/YYYY.

I would like to use a unique format which will be YYYY/MM/DD.

I try to standardize using the expression below:

DATE#(LastDate,'YYYY/MM/DD')

But, after to run my script, there is no modification, I still have the both formats.

Please could you help me to resolve this problem.

Thank you in advance for your help.

Re: Stardardize the date format

dplr-rn — Tue, 24 Sep 2019 15:31:12 GMT

date# function is to convert a text to date/numeric. not to format it
since you say it is within same column try with this DATE(LastDate,'YYYY/MM/DD') and check results

if it doesnt we may need to be more creative. check and let me know

Re: Stardardize the date format

Black_Hole — Wed, 25 Sep 2019 12:24:22 GMT

Hello @dplr-rn ,

The expression above works perfectly.

Thanks a lot for your help 👍