Adding 1 Min to a DateTime Variable

[abdullah_noor23]

Hi,

I have a dataset that has a column name Effective Start Date and Effective End Date. The Data type for both this variable is Date Time. 

Whenever there is a new record in the data set, I have to update the Effective End Date. Currently I am doing this with Date Time Now.

At the same time I need to update Effective Start Date = Effective End Date + 1 minute. 

Can you tell me how can I put this(Effective Start Date = Effective End Date + 1 minute) into the formula tool for DateTime variable? Is there any other ways to do it? Please share.

[alexnajm · Accepted solution]

DateTimeAdd([Effective End Date],1,"minutes")