Change Date Format

[MyMelody]

I have a field which is a Date/Time. I want to display this field with format dd/mm/yyyy. I also want to display the time if it's AM or PM. How can I do that?

[cheonsa]

Hi @MyMelody,

 

I have a code that will convert the date format to dd/mm/yyyy and will determine if the time is AM or PM.

You may try this one:

CONVERT(VARCHAR(10), [@field:TimeCreated], 103) + ' ' + LTRIM(RIGHT(CONVERT(CHAR(20), [@field:TimeCreated], 22), 11))

The result will be like this:

 

Hope this helps.

 

-kristina

 

 

[DefinitelyNot31337]

If you're using a DataSource field (i.e. field coming from your DataSource / Table), you may just set a custom localization format of: d/M/yyyy t

Works fine for me.

 

 

`DN31337

[ParkLoey]

Hiyaa there! In cases when you want a different format of your date, you can refer to the list provided in this forum post: