Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.