[acs] Date of Entry Filter

[CheeseDog]

Can anyone tell me what's worng with this filter condition?

 

Student.Personal.Dateentry>Var('EntryDate')

 

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

[john]

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!)

[CheeseDog]

Tried that format as well John.

 

Get the same result

[NickBuckel]

It could be because Facility isn't seeing both of those things as dates. Try this, to explicitly cast everything as a date:

 

datekey(Student.Personal.Dateentry)>datekey(Var('EntryDate'))

 

Nick

[CheeseDog]

It could be because Facility isn't seeing both of those things as dates. Try this, to explicitly cast everything as a date:

 

datekey(Student.Personal.Dateentry)>datekey(Var('EntryDate'))

 

Nick

 

Thanks Nick