Hey all! So glad I found this active forum.
[Background: There is an ugly database I've inherited, which contains a generic text field holding a piece of information I want. Thankfully the data entry is consistent and I was able to use the Left command to isolate the data that I want to use as a date. Then I used DateDiff command and successfully calculated the difference between Today and the piece of information I extracted by using Left command.]
So now I have this expression which I've identified as [TimeLeft] which displays the DateDiff results successfully.
For this query however, I only want to display records which [TimeLeft] is less than 8 (including negative numbers).
I've tried adding criteria of "<8" and that definitely doesn't work. My current code is:
TimeLeft: DateDiff("d",Now(),[ProjectDeadline])
Is it possible to add criteria to a column which is calculating DateDiff at the same time? How can I apply Criteria to limit the results?
Thanks for your help everyone!:banghead:
-Wes-
[Background: There is an ugly database I've inherited, which contains a generic text field holding a piece of information I want. Thankfully the data entry is consistent and I was able to use the Left command to isolate the data that I want to use as a date. Then I used DateDiff command and successfully calculated the difference between Today and the piece of information I extracted by using Left command.]
So now I have this expression which I've identified as [TimeLeft] which displays the DateDiff results successfully.
For this query however, I only want to display records which [TimeLeft] is less than 8 (including negative numbers).
I've tried adding criteria of "<8" and that definitely doesn't work. My current code is:
TimeLeft: DateDiff("d",Now(),[ProjectDeadline])
Is it possible to add criteria to a column which is calculating DateDiff at the same time? How can I apply Criteria to limit the results?
Thanks for your help everyone!:banghead:
-Wes-