Solved

StringToMoment giving weird result

5 months ago
22 November 2023
3 replies
41 views

Userlevel 5

+7

gdiepen
AIMMS Champ
131 replies

When using the StringToMoment function to calculate the number of hours between two dates and running into something weird:

As you can see AIMMS tells me 0 minutes elapsed between 10:00:00 and 11:00:00

My guess is that somehow AIMMS is assuming the referencedate as UTC time, while it assumes the second date as my local timezone.

I have also tried to use

StringToMoment("%c%y-%m-%d %H:%M:%S %TZ", [minute], "2023-10-11 10:00:00" , "2023-10-11 11:00:00 UTC")

To indicate I really want to have the second timestamp as UTC, but that did not help.

What is the small/obvious thing I am overlooking here?

icon

Best answer by MarcelRoelofs 23 November 2023, 17:17

View original

3 replies

M

Userlevel 4

+5

MarcelRoelofs
AIMMSian
92 replies
5 months ago
23 November 2023
Answer

@gdiepen

Maybe set this option that has helped me at times: use_UTC_forCaseAndStartEndDate

Userlevel 5

+7

gdiepen
Author
AIMMS Champ
131 replies
5 months ago
23 November 2023

@MarcelRoelofs That is helping….

When I just checked in my project that was created a couple of days ago, this option was set to the non-default value “On”. After switching this option back to the default value “off” then everything was working as expected.

In the help it is mentioned that the default is different for new projects vs existing projects, but does not make it super clear.

Happpy that I do have a fix now, but a bit surprised the defaults in a new project do not lead to expected results without modifying some project settings

M

Userlevel 4

+5

yeah, we went meticulously through a lot of things when introducing multi-time zone support in WebUI, but both for time zone support and character encodings the same thing is true: it is made easy to do wrong, and hard to do right.

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded