Jump to content

Doing find for CurrentDate...Y2k problem?


This topic is 8393 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...

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? ;-)

Link to comment
Share on other sites

  • 9 months later...

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

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 cool.gif" border="0

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8393 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.