Discussion board where members can get started with QlikView.
Hi all I'm using the alt function in the script in order to have 1 date format
alt(date#(text(Date), 'YYYY/MM/DD'), date#(Date, 'YYYY/MM/DD'), date#(Date, 'DD/MM/YYYY'), 'No Date Found') AS Date
for some reason, the script does not recognize the format for a date as 5.12.2018
I tried to use the following
But I keep receiving "No Valid Date" value instead of 05/12/2018
What am I doing wrong?
If it is not working for you, try to check the specific value it that has extra spaces around or some other time elements.