Formula to change date format

[drckarcher]

Hi,

I am importing a date/time field from another application. Its format is

2022-04-14T09:00:00 

How can I convert this to 14 April 2022 using a formula?

I get as far as Left([@field:EventDateTime],10)  (resulting in 2022-04-14) but can't figure out how to proceed from here,

Many thanks!

[autonumber]

Hello @drckarcher - you may check this forum post

 

[autonumber]

Just to add, you can set the format of the Date on the formatting settings on the DataPage so it will display as 21 April 2022.

[cheonsa]

There is an SQL formula that you can use to change the format of a Date field to DD MMM YYYY. 

CONVERT(varchar,[@field:FIELDNAME],106)

However, this formula only works in DataPages not in Formula Field.

 

 

 

[PotatoMato]

Hi! Just to add, you may check this link for different Date formats on SQL: https://www.sqlshack.com/sql-convert-date-functions-and-formats/

[JoshuaAnderson]

I want to know the formula to change date format and for that I am searching for it online and I am glad I have found your post.

[NiceDuck]

You may also try the options here https://www.w3schools.com/sql/func_sqlserver_convert.asp 

[User05012023]

I have also faced a similar issue, but I wanted to get the date into a more usable format, here I am using UK format, but you can move the day and month around - 

Day / Month / Year

RIGHT(LEFT(CONVERT(VARCHAR, [@field:JobDate], 120), 10),2)

+ '/' + RIGHT(LEFT(LEFT(CONVERT(VARCHAR, [@field:JobDate], 120), 10),7),2)

+ '/' +LEFT(LEFT(CONVERT(VARCHAR, [@field:JobDate], 120), 10),4)

 

Hopefully this helps getting the date formatted within a formula field outside a datapage. 

[RuisiHansamu]

Maybe this forum post would be helpful: