MIS Systems Thread, Date of Entry Filter in Technical; Can anyone tell me what's worng with this filter condition?
I have EntryDate setup as a date in variable ...
10th May 2011, 06:11 PM #1
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
IDG Tech News
10th May 2011, 11:10 PM #2
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!)
11th May 2011, 10:01 AM #3
Tried that format as well John.
Get the same result
11th May 2011, 11:50 AM #4
- Rep Power
It could be because Facility isn't seeing both of those things as dates. Try this, to explicitly cast everything as a date:
2 Thanks to NickBuckel:
CheeseDog (11th May 2011), john (11th May 2011)
11th May 2011, 01:17 PM #5
Originally Posted by NickBuckel
By mrbios in forum Internet Related/Filtering/Firewall
Last Post: 29th September 2010, 09:49 AM
By steveg in forum Windows
Last Post: 23rd November 2009, 11:24 AM
By WStore_Dan in forum Our Advertisers
Last Post: 19th May 2009, 10:46 AM
By kerlj001 in forum MIS Systems
Last Post: 15th December 2008, 04:41 PM
By SimpleSi in forum General Chat
Last Post: 28th January 2008, 11:14 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)