And if I remove the quotes from 09/30/2017, then I get an error saying I can't compare date and float values.
2 of 2 people found this helpful
Surround the date value with pound signs, not quotes.
Thank you, it worked! I am curious to know, why?
Is it a rule to always surround date with # and strings with ''?
1 of 1 people found this helpful
Suppose you wanted to have a string (not date) value of 01/30/2018. You would have to surround it with quotes. So that's why your calc with quotes around the date value was failing with the error of comparing a date field with a string.
No delimiters around numbers. Quotes around strings. Pound signs around dates.