convert date column to dd-mm-yyyy format

[vinayvnn]

Start Date

18-Sep-2023

01-Feb-2023

02-Apr-2018

29-Mar-2017

01-Aug-2022

15-May-2024

01-Jul-2015

01-Feb-2015

Hey, I have the above dates available, I wanted to convert the same column into dd-mm-yyyy format. Could be helpful if someone help me on this regard.

[ShankerV · Accepted solution]

Hi @vinayvnn 

The below formula in the formula tool, will help to get your expected output.

datetimeformat(DateTimeparse([Start Date],"%d-%b-%Y"),"%d-%m-%Y")

Many thanks

Shanker V