How to get the correct date format?

[wendyzjy]

hi Experts,

would like to ask a question on the data format:

if i want to change the end date format from 2022-11-01 to 2 months earlier(supposed to be 2022-09-01, how can i change this formula below?

[ShankerV · Accepted solution]

Hi @wendyzjy 

Please use the below.

DateTimeAdd([End Date],-2,"Months")

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @wendyzjy 

If you need to update the same existing column then select the same column name as highlighted below.

Many thanks

Shanker V

[wendyzjy]

Awesome! Thank you!