In my Resets Table, I need the Equipment Ordered Date to be blank if there is not a numeric value in the Table/Field - Projects Order Equipment.
The field - Treat blank values as "0" is unchecked
And I have this formula to provide the date the equipment needs to be ordered by in my Resets Table
If(not IsNull([Project - Order Equipment]),WeekdayAdd([Start Date],-[Project - Order Equipment]))
The result I keep getting (and I have tried several variations) is the Start Date.
------------------------------
Hans Hamm
------------------------------
Question
Null Field and working with dates
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.