Home > Forum > Actions > Substitutions for one day longer than expected?

Substitutions for one day longer than expected?

0

09.01.2025

11:25

Hi everyone,
There is something that has been a thorn in my Webcon enviroment for some time. I thought that new version will solve this but unfortunatelly didn't.
The problem is that in my leave of absence workflow I have an action that sets up substitution for the time a person is out of office. When I run a test (see left side of the enclosed screen) the SQL query shows correct dates of substitution (the same as te person's absence). When the acton runs the substitution is set to last for one day longer than expected. Why is this like that? Where am I doing something wrong?

09.01.2025

12:32

Hi,
That's quite strange - I've checked it myself and it works fine (screen)
Maybe it's something with the time zone settings on your sql server?

Solution (0)

Helpful (0)

Wrong answer (0)

09.01.2025

13:42

In reply to: Jacek Wojnar

Hi,
That's quite strange - I've checked it myself and it works fine (screen)
Maybe it's something with the time zone settings on your sql server?

Seems to be set right. Both SQL Server and Webcon Services are run on the same virtual machine.

SQL Server: (UTC+01:00) Sarajewo, Skopie, Warszawa, Zagrzeb
Windows Server: (UTC+01:00) Sarajewo, Skopie, Warszawa, Zagrzeb

Solution (0)

Helpful (0)

Wrong answer (0)

10.01.2025

08:44

In reply to: Michał Ludwiczak

Hi,
did you check what you have in the table [Substitutions] after creating the substitution (columns: SUB_SubstitutionStart, SUB_Substitutionend).

And maybe it's stupid but you can try adding the substitution to the hour, e.g. 22:59:59 and see how it is created then.

Solution (0)

Helpful (0)

Wrong answer (0)

13.01.2025

13:37

In reply to: Jacek Wojnar

This is really strange, but other substitutions are set ok. I've tried to figure out what is the difference between this faulty one and those other - I see no such difference. I will continiue the investigation though :)

Solution (0)

Helpful (0)

Wrong answer (0)

Privacy overview