Date field

[master_student]

Hello dear community,

I have a date field format timestamp. How to convert it into Date 'DD/MM/YYYY' I need to convert it in the script.

Thanks for your help.

[master_student]

Yes.

An other date field in my database that need to be converted , the actual format is MM/DD/YY

The expected result is DD/MM/YYYY

Thanks for your help.

[tamilarasu]

Hi,

For your first question,

1). Date(Timestamp(DateField/86400+25569),'DD/MM/YYYY')

Second question.

2) Date(Date#(DateField,'MMDDYY'),'DD/MM/YYYY')