drckarcher Posted March 7, 2022 Report Share Posted March 7, 2022 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! Quote Link to comment Share on other sites More sharing options...
0 autonumber Posted March 7, 2022 Report Share Posted March 7, 2022 Hello @drckarcher - you may check this forum post JoshuaAnderson 1 Quote Link to comment Share on other sites More sharing options...
0 autonumber Posted March 7, 2022 Report Share Posted March 7, 2022 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. JoshuaAnderson 1 Quote Link to comment Share on other sites More sharing options...
0 cheonsa Posted April 27, 2022 Report Share Posted April 27, 2022 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. Quote Link to comment Share on other sites More sharing options...
0 PotatoMato Posted May 21, 2022 Report Share Posted May 21, 2022 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 1 Quote Link to comment Share on other sites More sharing options...
0 JoshuaAnderson Posted May 31, 2022 Report Share Posted May 31, 2022 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. Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted June 4, 2022 Report Share Posted June 4, 2022 You may also try the options here https://www.w3schools.com/sql/func_sqlserver_convert.asp JoshuaAnderson 1 Quote Link to comment Share on other sites More sharing options...
0 User05012023 Posted January 6 Report Share Posted January 6 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. Quote Link to comment Share on other sites More sharing options...
0 RuisiHansamu Posted September 5 Report Share Posted September 5 Maybe this forum post would be helpful: Quote Link to comment Share on other sites More sharing options...
Question
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!
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.