topic Re: Date Formatting Registration Date Column - Converting into same date format in App Development

Date Formatting Registration Date Column - Converting into same date format

rastogi_vinayak — Mon, 31 May 2021 10:34:07 GMT

Please give me the idea how to convert registration column date format into same date formatted as "Date of Incident" column (DD-MM-YYYY)

Thanks in Advanced..!!

JuanGerardo — Mon, 31 May 2021 10:43:13 GMT

Try:

Date(Date#(RegistrationDate, 'M/D/YYYY'), 'DD-MM-YYYY')

rastogi_vinayak — Mon, 31 May 2021 10:56:04 GMT

thanks for reply @JuanGerardo

I try the same but it is not working

Date(Date#("Claim Registration Date", 'MM/DD/YYYY'), 'DD-MM-YYYY') as "Claim Registration Date"

please suggest another expression.

NitinK7 — Mon, 31 May 2021 12:57:55 GMT

can you attach here same data in excel file for those two fields only

Vikash — Mon, 31 May 2021 13:07:00 GMT

Hi,

Try : date("Claim Registration Date",'DD-MM-YYYY') as "Claim Registration Date"

Vik