query results for specific date

[antonyx]

hi, i have certain jobs and i want to select them based on the job date.

in my current query, i use the job date parameter
[Enter a Date:]

when the user types in the date, then the jobs for that date and their corresponding information is displayed.

however, i have created a form for this query displaying the results as a datasheet.

instead of the user having to enter the date for the query manually, is there any way to modify the query to only show results for the current day.

eg. today is the 24/02/06.. so i would like the results from the query to automatically show the jobs for that date. this way, only todays jobs will be shown in my form.

 

[antonyx]

hahaha, its so easy, to show all the records for todays date just put Date() in the date field's criteria

 

[jarvjarv]

Can the same apply to a birthday for example?

if i had a table with peoples date_of_birth in the format dd/mm/yyyy

could i get a query to take the dd ('day()'?) and mm ('month()'?) then remind me that it is someones birthday?

 

[atarazon]

You can do something like:

Format(Date(),"mm/dd")

in the criteria field. In the query, you'll also want to format the Employee's BDay field to display a "mm/dd" format. See the attachment for a screenshot example. Hope this helps.