Kien
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Compare DateTime against a point in time (in local time zone)
Thanks a lot everyone. All your replies have contributed to me crafting the right expression. In the end I wanted to compare against midnight of today so I can filter and only process items that are created between now and midnight (last night) in the current timezone. Note that $orderDate is stored properly in UTC format. The expression ends up being this (I know, not very elegant…): Date.parse($orderDate) >= Date.parse(Date.now().toLocaleDateString()+“T00:00:00.000-0” + ((Date.now().toLocaleDateTimeString({timeZone:“US/Eastern”, format: “HH”}) - Date.now().toLocaleDateTimeString({timeZone:“UTC”, format: “HH”})) * -1) + “:00”) This following expression would give me the proper date/time I needed (which is today at midnight in the -05/US-Eastern timezone) to compare my $orderDate against. Date.parse(Date.now().toLocaleDateString()+“T00:00:00.000-0” + ((Date.now().toLocaleDateTimeString({timeZone:“US/Eastern”, format: “HH”}) - Date.now().toLocaleDateTimeString({timeZone:“UTC”, format: “HH”})) * -1) + “:00”) Value at the time of this writting: 2022-01-12T05:00:00.000 UTC4KViews1like1CommentCompare DateTime against a point in time (in local time zone)
Hi, I’m having a hard time trying to figure out a way to compare a DateTime property (which is stored in UTC) to a point in time i.e. Today midnight (in the current local time zone which is US/Eastern -05:00)… The closest thing came to find is Date.parse(Date.now().toLocaleDateString()+"T00:00:00.000-05:00") which in turns gives me “2022-01-12T05:00:00.000 UTC”… but I don’t want to hard code the “-05:00” portion as during DST it would be -04:00… Any ideas? Thanks!5.4KViews0likes5Comments