I have a BeginDate and EndDate in a database. I want to be able to list those records if todays date is within the date range of BeginDate and EndDate. I am unsure of the coding on this. Has anyone done this and can give me some help? Thanks.
Depends on the database platform as to exactly what function you'd use, but essentially:
WHERE now() > BeginDate
AND now < EndDate
That's all there is to it.
Some databases let you do BETWEEN clauses, so even neater
WHERE now() BETWEEN StartDate and EndDate.
Just be careful to do some testing as to what happens when today *is* the end or start date, you may want them included or excluded depending on your requirements.
You're not using the CF function, as to do so would mean wrapping up the CF now() call in a CFQueryParam and passing it around as a variable, which is inefficient. I've never used FileMaker but Googled "Filemaker get current date" and it says to use "Get(CurrentDate)" - give that a go.
No, you shouldn't have to convert anything.
Assuming "Get(CurrentDate)" is correct (which as I said was from a quick Google, I've never used the DB you're using) it will return a date object. Assuming your dates are stored in the database as dates as well and not strings or something silly, it should be fine.
What does the error say?
Okay, well you need to help me out and find out what the function name is you need, as there's little point me doing that for you. You'll need to check the documentation for the database platform.
Europe, Middle East and Africa