roattw Posted December 19, 2019 Report Share Posted December 19, 2019 I have a field that contains a 24 hour clock time as 4 digits. It is a start time. They are number fields (but could be text). Entered simply as #### (ie 1300) I would like to populate another hidden field with this number converted to a time value of 13:00. Ive tried CAST and CONVERT. I can do it in Excel with several different formulas but I cant find a Capsio equivalent that doesnt error. =TEXT(field]cell,"0\:00") Try_Convert(time(0),LEFT([@field:DTN_Start_value],2) +':'+ RIGHT([@field:DTN_Start_value],2)) Any thoughts? Quote Link to comment Share on other sites More sharing options...
Meekeee Posted January 15, 2020 Report Share Posted January 15, 2020 Can you try this formula: CONVERT(DATETIME, CAST(LEFT([@field:Time],2) +':'+ RIGHT([@field:Time],2) AS VARCHAR(10)), 114) Quote Link to comment Share on other sites More sharing options...
Pawan Posted March 8, 2020 Report Share Posted March 8, 2020 how can i convert below text to date Saturday, 29 February 2020 19:26 Quote Link to comment Share on other sites More sharing options...
PotatoMato Posted February 26, 2022 Report Share Posted February 26, 2022 Hi @Pawan. You can use this formula: CONVERT(DATETIME, [@field:DATE], 101) and also check this How-to article: https://howto.caspio.com/function-reference/ -Potato Quote Link to comment Share on other sites More sharing options...
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.