Date of Entry Filter
Can anyone tell me what's worng with this filter condition?
I have EntryDate setup as a date in variable but when I run a report with EntryDate=30/12/2010 for example I get a list of pupils who are born on the 31st of any month
does it not want the date in the format dd-mm-yyyy which is the standard way I usually use them?
(Awaits @michael2k6 coming and telling me i'm a plank as i've missed the really obvious!)
Tried that format as well John.
Get the same result
It could be because Facility isn't seeing both of those things as dates. Try this, to explicitly cast everything as a date:
Originally Posted by NickBuckel