Arcade Expression Converting Text to Date

Question

I am seeing if anyone has a solution for converting text to date that is in the following format 201909050425 within Arcade Expressions?

XanderBakker · Answer

Hi eshreve_azdema ,

Your expression will not work, since you are using "Date" which is not a value, but an existing function. Have a look below: I create a date with the function Now, Then I convert to UTC with ToUTC and I apply the DateAdd function. All intermediate results are written to the console (messages part) and you can see the different date-time results.

AZ911GIS · Answer

Xander Bakker‌

How would I offset the time to local time?

I tried adding this line of code but it looks like it is not taking:

var pacificTime = DateAdd(ToUTC(Date), -7, "hours");

XanderBakker · Answer

Hi Eric Shreve I don't think it is formatted as "YYYYMMDD" since you have more numbers, or are you only interested in the date and not the time? In case your format is "YYYMMDDHHmm" you would use this: var txt = $feature.VALID; // in case your field is called "VALID" var YY = Number(Mid(txt, 0 , 4)); var MM = Number(Mid(txt, 4 , 2)) - 1; var DD = Number(Mid(txt, 6 , 2)); var HH = Number(Mid(txt, 8 , 2)); var mi = Number(Right(txt, 2)); return Date(YY, MM, DD, HH, mi);‍‍‍‍‍‍‍‍‍ In case you are only interested in the date not the time, you would use this: var txt = $feature.VALID; // in case your field is called "VALID" var YY = Number(Mid(txt, 0 , 4)); var MM = Number(Mid(txt, 4 , 2)) - 1; var DD = Number(Mid(txt, 6 , 2)); return Date(YY, MM, DD);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍