Hello All. I'm considering purchasing DBMan for our company. I have a form/perlscript combo which I'd like to write the DBMan datafile. Mostly, users are going to use DBMan to read/sort the data and use the Excel export mod.
My problem is that sorting and searching by Date is going to be very important, and it isn't working! My database has a date field defined, and I can add a record with no problem. It uses the 6-Aug-2000 format. But I don't know to write a date in that format to my database using my form.
I realize this might be more of a Unix/Perl question. Right now I'm writing the date like this through my perlscript:
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
$year += 1900;
$Date = $mon . "-" . $mday . "-" . $year;
This writes the date in the 8-26-2000 format and works ok. But DBMan doesn't like it!
So finally.... my question... How do I write a date so that DBMan will read it as a valid date field/format?
And after I've got the date written properly... when I'm doing a DBMan search, do I have to actually spell out the date in the 26-Aug-2000 format?
Or to search a range, do I use >26-Aug-2000 to show records after that date?
Thanks very much. I appreciate the help.
My problem is that sorting and searching by Date is going to be very important, and it isn't working! My database has a date field defined, and I can add a record with no problem. It uses the 6-Aug-2000 format. But I don't know to write a date in that format to my database using my form.
I realize this might be more of a Unix/Perl question. Right now I'm writing the date like this through my perlscript:
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
$year += 1900;
$Date = $mon . "-" . $mday . "-" . $year;
This writes the date in the 8-26-2000 format and works ok. But DBMan doesn't like it!
So finally.... my question... How do I write a date so that DBMan will read it as a valid date field/format?
And after I've got the date written properly... when I'm doing a DBMan search, do I have to actually spell out the date in the 26-Aug-2000 format?
Or to search a range, do I use >26-Aug-2000 to show records after that date?
Thanks very much. I appreciate the help.