Variable Pay: How to change date format from dd/MM/yyyy to MM/dd/yyyy

[ES1]

Hi,

How to change date format from dd/MM/yyyy to MM/dd/yyyy in Variable Pay?

I wanted to use the function toDate but it can only accept format MM/dd/yyyy. The date format in the worksheet is dd/MM/yyyy.

Thank you.

Regards,
Elly Sia

[xavierlegarrec]

Hi ellysia

Sorry for the late reply.

Please see the below:

From:

https://blogs.sap.com/2020/09/29/how-to-use-dates-in-formulas-in-compensation-worksheets/

All the best

Xavier