Trigger time in queries

[spleewars]

i believe trigger time in queries is possible but i need some suggestion. let say i set a new record with today's date. passing the table through the query, what parameters are to be used on "date" to make the record visible in 3 months time?

Clara

[Rabbit]

You can use the DATEDIFF function to see how many months have elapsed between the current date and the date on the record.

[spleewars]

hi Rabbit once again :)

i cannot understand how can i use the DATEDIFF in this situation. I mean how is it possible to find the elapsed time from a start date to an end date using the latter function?

[spleewars]

followed your advice and done :) thanks again