Date Function
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.
Best Answer
-
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
Answers
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
