Convert date from 01/01/2023 to 1 Jan 2023

[Kartik2]

How can i convert date format from 01/01/2023 to 1 Jan 2023 ?

[PhanThanhSon]

Hi,

Try that out; the abbreviation for the month depends on what you have defined in the Load Script.

date('08.01.2024', 'dd MMM YYYY')

Best regards Son

[Kartik2]

Isn't there any function or some expression?

[LRuCelver · Accepted solution]

As @PhanThanhSon has pointed out, you can use the Date() function to change the way a date is formatted. In your case this expression should work both in the script and the frontend:

Date(DateFieldWithOldFormat, 'D MMM YYYY') as DateFieldWithNewFormat

[PhanThanhSon · Accepted solution]

Hi,

you can set it in the backend like this:

And in the frontend you can try this, 

Best regards Son