as you can see ,I want to change to dateformat to 02Jan2022 ,how can I deal with it ?
Hi @wu cong?
There are 2 ways to update the date format to custom date format:
Click on Format Icon on the toolbar and select "More datetime formats"
Enter the formatting type as shown below:
ddMMMyyyy
Click on the function icon on the toolbar and navigate to Dates and times to DATEFORMAT() as shown below Use the DATEFORMAT() Function to update the format
DATEFORMAT(DATE1, 'ddMMMyyyy')
Hope this helps.
Apeksha
hi, Apeksha
thanks for your reply. the raw data the day format is one digit below 10 , such as 1 May 2022 not 01 May 2022.
we change to dd MMM yyyy for some recon .
Hi Wu,
Please confirm if you want to retain a single-digit day such as 1 May 2022 or a double-digit day such as 02 May 2022.
Best,
Apeksha
I want to a double-digit day such as 02 May 2022.
Hi @wu cong? ,
Please try the below function:
DATEFORMAT(DATE1, 'ddMMMyyyy')
Either 'ddMMMyyyy' or 'dd MMM yyyy' will give you a double-digit day.
Best,
Apeksha