Override a date formula field?
Hello, I've created a formula date field to auto-populate the date two weeks from today today()+Days(14) but I want to allow the users to override it. Normally they would have a call eve...
Forum Discussion
Hey Julie,
It sounds like you'd need to another Date field the User can optionally fill out to override the default calculation. For example,
If ( // Was an override provided? If so, use it instead! not IsNull([Date Override]), [Date Override],
// Default to your existing two week logic Today() + Days(14))
Hopefully that gives you some ideas!
------------------------------
Brian Seymour
------------------------------