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

shahafei2 — Wed, 25 Nov 2020 16:16:04 GMT

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?

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

tresB — Wed, 14 Aug 2019 09:08:58 GMT

It works:

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