Forum Discussion
UrsulaLl
7 years agoQrew Assistant Captain
What type of field is [End Mileage] ? is it a text field, or numeric, or date? If it is not a text field, then it will never return anything, since you are searching for text: 'last wk'.
If it is a text field, then maybe last week, there were no records. I would test this by putting in other text, like 'last month' or 'two weeks' or any other responses this field may have. It may be possible that it isn't returning anything due to that.
If it is a text field, then maybe last week, there were no records. I would test this by putting in other text, like 'last month' or 'two weeks' or any other responses this field may have. It may be possible that it isn't returning anything due to that.
JohnBarulich1
7 years agoQrew Cadet
No, I am using QuickBase's relative date ranges. IR is (Is During), and 'last wk' is a built in command with their API based on the documentation