Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I hope all is well.
I have a date field with that format
valid_from |
12/08/2015 00:00 |
I did the expression bellow in the script to extract only the date DD/MM/YYYY
Date(Date#(valid_from, 'DD/MM/YYYY'), 'DD/MM/YYYY') AS detection_date but it returns nothing
do you have any idea please?
Thanks
Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm'))) as detection_date
or
Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm')),'DD/MM/YYYY') as detection_date
Hey Wiem,
In your original string, the date and time is formatted like 'DD/MM/YYYY hh:mm'
You need to make sure that in the Date#(valid_from, 'DD/MM/YYYY') function the date itself is formatted as how it is
in the original string so:
Date(Date#(valid_from, 'DD/MM/YYYY hh:mm'), 'DD/MM/YYYY') AS detection_date
Good luck!
Ivo
Thanks but it didn't work.
Can you share your script or a sample app to look into?
Hi,
I hope this is helpful to you
Floor(valid_from) as valid_from
Regards,
Mahesh