Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shahafei2
Contributor

alt(date#) function for works for different date formats but not works for d.m.yyyy

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

date#(Date, 'd.m.yyyy')

date#(Date, 'D.M.YYYY')

date#(Date, 'd.mm.YYYY')

date#(Date, 'DD.MM.YYYY')

But I keep receiving "No Valid Date" value instead of 05/12/2018

What am I doing wrong?

1 Reply
MVP
MVP

Re: alt(date#) function for works for different date formats but not works for d.m.yyyy

It works:

Capture.PNG

If it is not working for you, try to check the specific value it that has extra spaces around or some other time elements.