Need a second pair of eyes here.
Question: Can anyone see my mistake?
Feature request: It would be nice to use the Conditional Statements in formulas to display an empty value. See the first formula. If [Date Acquired] is empty I would like [Expiry Date] to also be empty. Empty quotes (text) when the result is a number is not allowed. Converting to text like this: text(0) also doesn’t work.
[Date Acquired] = Date field; e.g. 09/23/2016
[Expiry (mo)] = Number field; e.g. 15
[Expiry Date] = Calculation field, result type = Date; e.g. 12/23/2017
Formula = IfNotEmpty([Date Acquired],([Expiry (mo)] * 2628000) + [Date Acquired],0)
[Days Until Expiry Date] = Calculation field, result type = Number
Formula = ([Expiry Date] – $now) / (60*60*24*30)
The second formula returns -570 but the # days between now and 12/23/2017 is about 100 less than that.
Can you send me your form template and I’ll play around with it?
I was hoping someone could quickly see my error.
Honestly, Brendan, it’s not worth your time. I’d gladly take you up on your offer if it was for one of my important databases but these are records of my makeup products.
You have better things to do than to trouble yourself with how many days left I have before I need to discard my eyeliner :)
Thanks for the offer, though!
.
