Forum Discussion

Occasional Contributor

7 years ago

aqConvert.DateTimeToFormatStr(aqDateTime.Today(),"%U") format is not work properly

Hi All aqConvert.DateTimeToFormatStr(aqDateTime.Today(),"%U") is return wrong week number. Ex i have evaluate the function format on date 02.05.2018, So current week number is 18 but this...

tristaanogre
7 years ago
nice, will_fetherolf! Then it's not a bug, just a misunderstanding of what's being returned.

so, %U will still work, you just need to make sure that you add 1 to any result to get the ISO standard week number.

However, it looks like %W is still what you're looking for. Just did a quick check and %W does it's numbering starting with 1 while %U numbers starting with 0. That's a documentation problem since %W also seems to note that the week numbering starts with 0.

In short... use %W to get the ISO standardized week number with weeks starting on Monday and numbering starting with 1.

will_fetherolf

Contributor

According to this page (https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqdatetime/date-and-time-format-specifiers.html), the function returns 0-53 for week numbers. So, the week containing January 1 would be week 0. You're right, we're currently in week 18, but the conversion function will always return one less.

tristaanogre

Esteemed Contributor

7 years ago

nice, will_fetherolf! Then it's not a bug, just a misunderstanding of what's being returned.

so, %U will still work, you just need to make sure that you add 1 to any result to get the ISO standard week number.

However, it looks like %W is still what you're looking for. Just did a quick check and %W does it's numbering starting with 1 while %U numbers starting with 0. That's a documentation problem since %W also seems to note that the week numbering starts with 0.

In short... use %W to get the ISO standardized week number with weeks starting on Monday and numbering starting with 1.

santoshthenge
Occasional Contributor
7 years ago
Hello All,

Thank you for reply.

As per the previous conversion. You suggest use %W instead of %U.
But the %W formater also not working properly.

Please check the below image: %W formater for current year its working correctly but for next year its return wrong value
- tristaanogre
  Esteemed Contributor
  7 years ago
  Then, as suggested before, open an issue with support with the appriopriate link at https://support.smartbear.com/message/?prod=TestComplete. In the meantime, you might have to write some custom conversion to count the weeks to get the number.