Brian, I tried both ways. 1. Current situation with A8 text field entering dates as 02-13-09 in the body of the report I entered Ctrl F7, 1, 4 then the convert below for rv1 with no hard return after the formula. It had no effect on the report, everything was collected.
2. I started a test database to a new directory and deleted all the data and changed the date fields to date fields, DMMDDYYYY, I'm in LA. In the report body I put P1F3<=TODAY OR P1F3=0 plus the fields I wanted in the report. The report when run pulled out the first correct data, hung the computer requiring a reboot and in the field put Ec6g or something similar. No epiphany yet, what next, consider me a newbie^2 Thanks Colin -----Original Message----- From: Brian Hancock <[email protected]> To: [email protected] Sent: Tue, 28 Apr 2009 5:14 pm Subject: Re: [Dataperf] Report selecting two conditions in one field 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 shopping in your closet instead! _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
