Formula Help on Date Field
Hi, I have a date field called "Release Date" and a formula date field call "Final Approval Date" Whatever the date listed in the "Release Date" field I have it formulated to subtract 28 days into t...
Forum Discussion
Hi, Derek (long time no talk)
Try this ..
[Release Date]-Days(Case(([Type],"digital",28,"digital & disc",35,"video",21,28)).
The "Case" function, which I underlined above, is varying the number of days based on the Type.
In this example, its
Try this ..
[Release Date]-Days(Case(([Type],"digital",28,"digital & disc",35,"video",21,28)).
The "Case" function, which I underlined above, is varying the number of days based on the Type.
In this example, its
- 28 days for digital
- 35 days for digital & disc
- 21 days for video
- 28 days for everything else
- Hi Debbie,
Indeed long time no talk:). Thank you very much for the formula it worked for me.
