Proper syntax for Date Query

[sparling]

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

[Anatoli]

I think it is the "-" in &-CurrentDate=Creation_Date

It should be &CurrentDate=Creation_Date

[sparling]

Doesn't work. With that change the query fails.

thanks for trying.

[Anatoli]

quote:

---

Originally posted by Lawrence:

Doesn't work. With that change the query fails.

thanks for trying.

---

Are you saying, that the CurrentDate is not name of the field?

Are you using the function [FMP-CurrentDate]?

[sparling]

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]?

[Anatoli]

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...