Hi Colin,
If Field is text field you will need to convert it to a date (which is actually a number), assuming the down under format of dd/mm/yyyy you would use /* Stored in RVx */ convert["DDMY99/99/9999";Field ] <= today OR Field="" which will set RVx to true (NOT 0) for Field less than or equal to today's date if Field is blank, it will set RVx to false (ie 0) for everything else including invalid dates (eg 32/4/2009), which convert[] to 0 Its generally not a good idea to use a text field to store a date as it will allow invalid dates to be entered If Field is already a date field then Field <= today OR Field = 0 Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, 29 April 2009 3:57 AM To: [email protected] Subject: [Dataperf] Report selecting two conditions in one field G'day all, I need a report which collects records based on a field (text field, ? should be date field). Records need to be included which; 1 Have a date equal to or before 'today's date' in the field and 2 If the same field is blank. Thanks Colin Lambert _____ Can't afford a new spring wardrobe? Go <http://www.stylelist.com/spring-fashion/spring-style/shopping-in-your-close t?ncid=emlweusstyl00000001> shopping in your closet instead!
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
