Date Function

jgneely72151

Hello,

I need to record prior dates in the following 3 date fields which is based on the date column. Can someone kindly share how to write a function for this and explain it? It is a possibility that I may have to included a 90 days prior field and I want to make sure I understand the formula enough to know where changes in the formula I'd need to change to reflect that. Your assistance is greatly appreciated.

Kelly Moore

Hey @jgneely72151

The number of required days can simply be subtracted from the original date.

date@row -60

date@row-30

date@row-15

Kelly

Kelly Moore

Hey @jgneely72151

The number of required days can simply be subtracted from the original date.

date@row -60

date@row-30

date@row-15

Kelly

jgneely72151

OMG...this is so simple...Gosh I was using a Workday formula that was giving me grief. I really appreciate your help. It worked like a charm.