Hi all, wonder if you can help. I have two date fields which I am trying to compare.
txtStartDate_disp - Computed Date field which takes its date value from another field
txtToday - Editable field which takes it value from a nightly agent to calculate todays date.
The formula I am using is
SELECT Form=“frmConSafe” & txtStartDate_disp <= txtToday
When I compare the two values in the view, it doesn’t return all of the documents, only the ones that meet the criteria and have a start date this month. There are other documents that meet the criteria but were created the month before but they are not returned.
Any ideas? Kinda bashing my head on this one!