Hi Michael, This seems like a good solution... The only minor irritation might be not being able to back arrow through the field during data entry, but a very slight price to pay
Regards Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Iannantuoni Sent: Wednesday, 21 October 2009 2:18 AM To: DataPerfect Users Discussion Group Subject: [Dataperf] Time Field query even easier . . . . . and finally . . . I ended up having three adjacent text fields working as if they were a time field as earlier - P1F1 - A2::E, P1F2 - A1::N, P1F3 - A2::E. This time however no field formulae were used, just range checks: 0 to 23 for P1F1 and 0 to 59 for P1F3 The second remains a no value may be entered field containing the initial value ":" For calculation purposes I currently have a hidden Time field with the formula: convert["T99:99";P1F1 ":" P1F3] Michael _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
