topic Re: Arcade Expression Converting Text to Date in ArcGIS Online Questions

Arcade Expression Converting Text to Date

EricShreve — Thu, 05 Sep 2019 15:09:39 GMT

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

Re: Arcade Expression Converting Text to Date

Anonymous User — Thu, 05 Sep 2019 16:40:15 GMT

Hi Eric Shreve‌,

I think you could probably modify the Arcade expression found in this thread to convert the string to a date:

https://community.esri.com/thread/222378-text-to-date-using-arcade-expressions

Hope this helps,

Peter

Re: Arcade Expression Converting Text to Date

XanderBakker — Sun, 12 Dec 2021 01:27:49 GMT

Hi Eric Shreve ,

What is the format of the data? Is 201909050425 in YYYYMMDDHHmm format or is it perhaps YYYYDDMMHHmm?

In case it is first month and then day, it would be something like this (assuming the you are using military hours):

// Date ( value , month , day , hour , minute , second , millisecond )
var txt = "201909050425";

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));

// Console(YY);
// Console(MM);
// Console(DD);
// Console(HH);
// Console(mi);

return Date(YY, MM, DD, HH, mi);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade Expression Converting Text to Date

EricShreve — Sun, 12 Dec 2021 01:27:52 GMT

Xander Bakker‌

It is formatted as YYYYMMDD. I switched the 'var txt' to 'VALID' which is the the field in the feature service and I am not able to get it working. Do you know what I am missing in the configuration?

// Date ( value , month , day , hour , minute , second , millisecond )
var txt = "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));

// Console(YY);
// Console(MM);
// Console(DD);
// Console(HH);
// Console(mi);

return Date(YY, MM, DD, HH, mi);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks,

Eric Shreve

Re: Arcade Expression Converting Text to Date

XanderBakker — Sun, 12 Dec 2021 01:27:55 GMT

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);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade Expression Converting Text to Date

EricShreve — Fri, 06 Sep 2019 21:48:33 GMT

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");

Re: Arcade Expression Converting Text to Date

XanderBakker — Fri, 06 Sep 2019 22:31:04 GMT

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.