Forum Discussion
lite4d
Jan 28, 2021Copper Contributor
Calculated expiration dates based on a field with no of extensions
I'm trying to calculate expiration dates based on an original expiration date then if it can be extended based on the number in a field use that number then it will add the amount of months in anothe...
Gustav_Brock
Jan 29, 2021Iron Contributor
lite4d That could be:
Expiration: DateAdd("m", 6 * (3 - [no of Extensions]),[shelf life exp]))