Arcade vs Time for local feature class

Markbe_utco

I'm simply trying to update a Date field with the current time. Ultimately I want to create an attribute rule that will automatically update the Date when a feature gets edited thus I have to use Arcade.

The following arcade functions all return a date value in UTC (six hours ahead of Mountain Time Zone):

- Now() --- returns date and time in UTC

- Date() --- returns date and time in UTC

- Timestamp() --- this is supposed to return a UTC value so....

- ToLocal(Timestamp()) --- returns date and time in UTC

- Today() --- Returns today's date but also sets the time to 6:00:00 AM - I'm not sure how this would get handled when the local time is past 6:00 pm and UTC time actually changes to the next day, I can only assume it would set the day to tomorrow's date and still set the time to 6:00:00 AM

Python's datetime.datetime.now() works just fine

Several of the function descriptions say, "Creates a date value in the local or system time of the client."  If the functions are actually working correctly what defines the client and how do I check its time setting?

It seems like it shouldn't be this difficult, am I missing something?

Any suggestions?

Edit: I've just tried this on my home computer with the same results.

Markbe_utco

Well, here is my workaround to obtaining local date/time values with the workaround for not being able to identify the first Sunday in November as a Sunday (

var currentDate = Timestamp() // current date & time in UTC
    
function MarchSecondSunday(inMonth, inYear){
    var sunday = 0 
    for(var x=0 ; x<=31 ; x++){
        if (ISOWeekday(Date(inYear, inMonth, x))==7){
            sunday = sunday + 1
            if(sunday == 2){
                return x
                break
            }
        }
    }
}


function NovemberFirstSaturday(inMonth, inYear){
    var saturday = 0 
    for (var y=0 ; y<=30 ; y++){
        if (ISOWeekday(Date(inYear, inMonth, y))==6){
            saturday = saturday + 1
            if(saturday == 1){
                console("saturday = " + saturday )
                return y+1
                break
            }
        }
    }
}


var dstStartDate = Date(Year(CurrentDate), 2, MarchSecondSunday(2, Year(currentDate))); // Second Sunday of March at 2:00 AM
var dstEndDate = Date(Year(CurrentDate), 10, NovemberFirstSaturday(10, Year(currentDate))); // First Sunday of November at 2:00 AM

if (currentDate < dstStartDate){
    console (dstStartDate + " ... Before DST Start ... " )
    return DateAdd(Timestamp(), -7, 'hours')
}
if ((currentDate >= dstStartDate) && (currentDate < dstEndDate)){
    console (dstStartDate+ " ... During DST ... " + dstEndDate)
	return DateAdd(Timestamp(), -6, 'hours')
}
if (currentDate >= dstEndDate){
    console ("After DST End ... " + dstEndDate)
    return DateAdd(Timestamp(), -7, 'hours')
}