Jump to content

Proper syntax for Date Query


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

Recommended Posts

I'm trying to query my database for the records from the current day.

<a href="FMPro?-db=database.fp5&-lay=mylayout&-format=response.htm&-error=error.html&-CurrentDate=Creation_Date&-sortField=Day_of_Year&-sortorder=descending&-maxRecords=10&-find">

The query works, but returns records from all "Creation_Dates",not just today's records. This seems like a simple syntax issue. Is there a quick fix for this, or a well-written description (with examples) of proper syntax use?

Thanks,

Lawrence

Link to comment
Share on other sites

quote:

Originally posted by Lawrence:

Yes, I'm am trying to use the function [FMP-CurrentDate], to retrieve all records from the Creation_Date field that happened today.

Should it read &[FMP-CurrentDate]?

IMHO almost all functions are in brackets e.g. &NAMEOFFIELD=[FMP-Cookie] and so...

Link to comment
Share on other sites

This topic is 8505 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.