: I have a page, that has the MS date and time picker active X control on
: The control is pointed to my date field in my table.
: What it's suppose to do is, when the user brings up the page the
: control should list the date that was entered into the DB, and then
: modify it using the calendar if needed.
: But instead, when they bring up the page. All the dates appear the
: same (it appears to bring up the date when I created the control)
: But now here is the real kicker, when I view the page. It works great!
: I didn't even know anything was wrong until somebody else told me
: about it.
: Any ideas, to why it works for me? but nobody else?
Can't tell you why it works for you, I know I had this problem on all my
machines running Windows 2k. Unfortunately, to fix it I don't remember the
exact param field but this should point you in the right direction. You
need to use notepad to open the html file and delete a param name field, if
you try to delete it while using the script editor, it will put the field
back when you save. I don't remember the exact name, but it is something
like "Date" or "TodayDate" or similar (see below for style of entry, this is
NOT the field to delete).
<PARAM NAME="MaxDate" VALUE="2958465">
Do a search for your OBJECT id = "your id of control", then look for a param
with the date value you are looking for. The dates are not in regular date
format, I think they are in Julian or some other format. You can use excel
to convert the date for you or some webpages will do it. Where you find
this number after the VALUE= field then delete that entire parameter
starting with the < and ending with the >. This should force the control
not to override the date from the database.