Borje Posted March 28, 2017 Share Posted March 28, 2017 (edited) Is that anybody here that can help with a little example what to do to have $newdate to a new string ex $dat1 with result 2017-03-28 without change the $newdate format. $newdate = "20170328" ; New date MsgBox(0, "Date is ", $newdate) ; Now is result 20170328 but I want to have 2017-03-28 as a result instead in a another string ex $date1 what to do? Edited March 28, 2017 by Borje Link to comment Share on other sites More sharing options...
water Posted March 28, 2017 Share Posted March 28, 2017 $newdate = "20170328" ; New date $newdate1 = StringLeft($newdate, 4) & "-" & StringMid($newdate, 5, 2) & "-" & StringRight($newdate, 2) MsgBox(0, "Date is ", $newdate1) My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Borje Posted March 28, 2017 Author Share Posted March 28, 2017 Thank you so much water that works perfect thanks again. Link to comment Share on other sites More sharing options...
water Posted March 28, 2017 Share Posted March 28, 2017 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now