Set cell value is converting certain dates to american format

rabbanir — Wed, 24 Sep 2025 13:13:53 GMT

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.

Re: Set cell value is converting certain dates to american format

rabbanir — Wed, 24 Sep 2025 13:31:41 GMT

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).

topic Set cell value is converting certain dates to american format in Product Forum

Set cell value is converting certain dates to american format

Re: Set cell value is converting certain dates to american format