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.
UrsulaLl
7 years agoQrew Assistant Captain
I was hoping that was not the case. I have had many issues with duration and date fields when running do_query, I had to do some funky stuff to get it to pull back correctly. I will be following this question to see if anyone comes up with a solution. Good luck!