Doing find for CurrentDate...Y2k problem?

[dimossi]

I have FMP 5.0v3 Unlimited and I am using CDML and try to do a find for all records for today using the following url:

FMPro?-DB=DATABASE.FP5&-Lay=1&-Format=webpage.htm&wo_date=[FMP-CurrentDate]&-Find

What then happens is it does a find for 9/13/1900 instead of 9/13/2000

Any suggestions? Thanks.

------------------

DIMO

[Vaughan]

That could be an Operating System issue rather than FileMaker Pro. Your little icon thingy indicates you're using Windows. Have you downloaded and installed all 11,1835 critical patches and updates from the Microsoft web site? ;-)

[ivyorg]

I'm but I'm having a similar issue. I'm trying to input "hidden" the current date when somebody's updating a profile (which is why I can't use autoenter creation date) to capture their most recent changes. The CurrentDate is sent DD/MM/YY, which is automatically translating it into 1901. I don't want to allow the individual the option of entering in their own date b/c of potential for "retroactively" filling out required forms. How can I "pass" the currendate in a different format (e.g. DD/MM/YYYY)?

Thanks

Bevin

[Garry Claridge]

We had a very similar problem, except ours was writing back in US format instead of Australian. So we used some Javascript to construct our own date string for writing back, and/or searching.

<script>

dCurrent = new Date();

dday = dCurrent.getDate();

dmonth = dCurrent.getMonth() + 1;

dyear = dCurrent.getFullYear();

smyDate = dday +"/"+ dmonth +"/"+ dyear ;

document.write('<input type="hidden" name="mydate" value="' +smyDate+ '">');

</script>

[ivyorg]

Instead of finding the "workaround," I switched the FMP-Current Date tag to the "Long" format, and thought that I appropriately had formatted my date field to say "Tuesday, July 31, 2001". However, every time that I try to submit that field, I get an error 500, date format invalid. Is there any reason why I shouldn't just capture this date as text instead, since I won't be doing any calcs with the date? Why should the error be coming up?

thanks

Bevin

[Jeff Spall]

i have an 'announcements' page where the link is a search which looks for a 'date to die' greater than today. the string is:

&-op=gt&datetodie=%2f%2f

that's the equivalent of the filemaker search '//' for today

will that work for you??

regards, Jeff

[Anatoli]

quote:

---

Originally posted by Vaughan:

That could be an Operating System issue rather than FileMaker Pro. Your little icon thingy indicates you're using Windows. Have you downloaded and installed all 11,1835 critical patches and updates from the Microsoft web site? ;-)

---

It shows you are not Windows expert, Vaughan!

Today it is 1 022 654 patches

[ August 01, 2001: Message edited by: Anatoli ]

[ivyorg]

that didn't work either from the web end. still says it's an invalid format for the date. i'm sure there's an easy javascript fix. this is just annoying. i hope the next fmp doesn't do me the great "favor" of keeping the date in the last century when getting field data from web.

bevin

[Garry Claridge]

We use Javascript to workaround this problem, and it works!

Garry