Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Black_Hole
Contributor II

Stardardize the date format

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.

Labels (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Stardardize the date format

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



View solution in original post

2 Replies
Partner
Partner

Re: Stardardize the date format

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



View solution in original post

Black_Hole
Contributor II

Re: Stardardize the date format

Hello @dilipranjith ,

The expression above works perfectly. 

Thanks a lot for your help 👍