cancel
Showing results for 
Search instead for 
Did you mean: 

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

ES1
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

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