Using Date Column to Add a Future Target Date

[Sidey1978]

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 solution]

How about

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

Iain

[CharlieS · Accepted solution]

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.

[Sidey1978]

Thanks both for sorting that one for me!

I knew it was going to be a simple one....*facepalm*

Cheers!