Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
hope that you can help with this,
I need to transform this date format for example:
'01/02/2018 44:00:33' need to transform it to '01/02/2018' noting that the format date is a number.
Thank you in advance
Hi
Depends how the date comes in (is it text or already a date number)
If its text you need to include the date# otherwise you can exclude it and just format it
Date( FieldDate, 'dd/MM/YYYY') Or
Date( Date#( FieldDate, 'dd/MM/YYYY HH:mm:ss'), 'dd/MM/YYYY')
If your date is a number, try like:
Date(Floor(DateField), 'DD/MM/YYYY') as NewDate
Try This
Date(Date#(Date field ,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY')
Hope this will help !!