Set cell value is converting certain dates to american format

[rabbanir]

Hi,

I have 2 different dates which I am entering into an excel spreadsheet, 14/07/2025 and 10/08/2025 using the Set Cell Value action within the MS Excel VBO - extended object.

The first date is entered fine however when entering the 2nd date it is entered as 08/10/2025:

It also converts the format to Date where as the first one stays as general.

Things I have tried:

• set English (UK) as the preferred authoring language in excel settings
• tried using the format cell action to format the column to a date with format "dd/MM/yyyy"
• used FormatDate() with above date format in the set cell value action.

It doesn't make sense as to why it is fine with the first date but not the second? any help would be much appreciated.

[rabbanir · Accepted solution]

UPDATE:

I switched the actions to use the MS Excel VBO rather than the extended one and it worked! It seems the Set Cell Value action in the extended object has not got the updated code from the base object or something? (It's the latest version from the dx as well).