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.
Solved! Go to Solution.
DateTimeAdd([Effective End Date],1,"minutes")