Data Format

[mario-sarkis]

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

[ruanhaese]

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')

[tresB]

If your date is a number, try like:

Date(Floor(DateField), 'DD/MM/YYYY') as NewDate

[vipin_mishra479]

Try This

Date(Date#(Date field ,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY')

Hope this will help !!