Solved: Formatting the date field : Please guide! - Page 2

Aditya_K1999 · 03-26-2024 01:41 AM

I have a table by the name of service availed. 2 fields in the table which I want to focus on are, Check-in date & Check-out date. Both are date time fields.

I have created a virtual column in the same table by the name of Check_In & Check_Out with the below formula: DATE(TEXT([Check-In Date],"dd/mmm/yy"))

I want my date to be displayed as : 23/Mar/2024

But right now even after using the formula it is being displayed as 3/25/2024

Aditya_K1999

For the display also to be decent I have changed the format into "long date format"

I realized this formula was never working. The only difference in my previous apps and this app was the long date format.

Thank you Suvrutt!

View solution in original post