How to get the correct date format?

Question

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 Answer

Hi @wendyzjy

Please use the below.

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

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @wendyzjy

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

Many thanks

Shanker V