CBTA date format issue: Why is the &today& token and other vbscript returning 06/13/2024 as 6/13/20?

[JeannineGardner1]

I have a question I hope someone can help me with:

CBTA date format issue: Why is the token/vbscript returning the date format as DMMYYYY without the zero before the single digit month; for example, instead of returning 06/13/2024 it's returning 6/13/2024?

Here are the details of this issue:

The CBTA script extracts data from SAP, creates a file and sends the resulting file to an AL11 directory.
The script navigates to the directory path, sorts the files in descending order such that the current date displays on the top row.
Then the date is captured with checkproperty (a parameter) and compared to today's date, which is picked up as it is displayed on screen (format MMDDYYYY) as expected.
However, when the parameter is compared to today's date using any of the three methods listed in item 5 below; the date does not include the zero before the month, where month is June for instance. For example, Jun is returned as 6/13/2024 (format MDDYYYY) instead of 06/13/2024. Therefore, the script fails with the following error:
Target: GridCell_0_MOD_DATE
- The 'GetCellValue(0, "MOD_DATE")' property is set to: 06/13/2024
- It has been compared to: 6/13/2024
- Using the operator: =

5. Received the same error using any/all of the 3 items below:

%today%
%=month(now())&"/"&day(now())+1&"/"&year(now())%
%=Month($today$)%/%=Day($today$)%/%=Year($today$)%

Thank you,

Jeannine

[rmangin]

Hello,

CBTA token %today% is referring to system dates format. It corresponds to the currently applied MS Window settings regarding the date format. Change your system date format to get another format that match the test user settings in the System Under Test (other way around may be also possible).

- Or - if your test user is using any SAP System date format which cannot match any available Windows system date format, then you may use a custom VBS function of your choice that can be added by a developer into the RTL.

Best Regards,
Rémi