Using Date Column to Add a Future Target Date

Question

Sup y'all

I have a column of date information which is the date a list of issues were raised. These have a timeframe of six weeks (say 42 days) to be cleared.

I'm struggling to figure out how to add a column simply adding 42 days to the DateRaised. I guess using a formula but I am not the best at using the datetime functions? I'm looking for a column headed TargetDate which is DateRaisedNew + 42 days...

Please can anyone shed some light on this for me?

Cheers

Sidey

ivoller · Accepted Answer

How about

DateTimeAdd([DateRaisedNew],42,"days")

Iain

CharlieS · Accepted Answer

Hi, @Sidey1978.

You are correct that a Formula tool can take care of this for you. Enter a new Ouptut Field in the Formula tool with the following formula and that should be it.

DateTimeAdd([DateRaisedNow],42,"days")

Let me know if you have any other questions.