drckarcher Posted March 7 Report Share Posted March 7 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 Report Share Posted March 7 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 Report Share Posted March 7 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 Report Share Posted April 27 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 Report Share Posted May 21 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 Report Share Posted May 31 Thanks for the suggestion. I did as you explained and it changed. :) Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted June 4 Report Share Posted June 4 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...
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
6 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.