Convert military date integer (20220515) to a true date variable (May 15, 2022).

433
2
05-22-2023 03:25 PM
BryanWright
New Contributor III

This seems like it should be easy but I can't seem to find an answer.  I have an integer variable storing military dates (YYYYMMDD) and would like to convert that into a date variable. Any help would be appreciated--thanks!

0 Kudos
2 Replies
JohnPlunkett
Esri Contributor

Hello - Have a look at this tool
Convert string or numeric time values into date format—ArcGIS Pro | Documentation
Use the Convert Time Field GP Tool (if you have access to ArcGIS Pro)

 

 

0 Kudos
BryanWright
New Contributor III

Thank you for the suggestion--I'll take a look at that.  I should have mentioned though that I was hoping to do this within Survey123 Connect, using a calculate formula similar to formulas/functions in Excel [Date(YYYY, MM, DD)] or R [ymd(YYYY,MM,DD)].

0 Kudos