Inconsistencies when extracting from a date when time is 12:00am

Bugs
1

Hi all,

Not sure if this is a bug, so I’m asking those who are used to manipulating dates.

I have a workflow that extracts a week number from a date. My dates are static (so timezone should not be relevant) and are all set with a time of 12:00am (beginning of the day).

I extract the week number twice, in the very same action.

image

Expected result: 50

image

Expected result: 201850

Surprisingly, for the very same inputed values I get different combinations. When for today December 10 at 12:00am I expect 50 and 201850, I get sometimes 49 and 201850, or 49 and 201849, or sometimes the correct values 50 and 201850.

Could it be somehow related to the fact that the time is 12:00am (the very first instant of the week)?

With thanks!

2

This topic was automatically closed after 14 days. New replies are no longer allowed.