topic Re: Convert date from 01/01/2023 to 1 Jan 2023 in App Development

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

Kartik2 — Fri, 08 Mar 2024 06:32:08 GMT

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

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

PhanThanhSon — Fri, 08 Mar 2024 07:31:17 GMT

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

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

Kartik2 — Fri, 08 Mar 2024 07:39:02 GMT

Isn't there any function or some expression?

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

LRuCelver — Fri, 08 Mar 2024 07:55:30 GMT

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

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

PhanThanhSon — Fri, 08 Mar 2024 08:19:18 GMT

Hi,

you can set it in the backend like this:

And in the frontend you can try this,

Best regards Son