By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,046 Members | 1,775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,046 IT Pros & Developers. It's quick & easy.

Trigger time in queries

P: 13
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
Apr 16 '12 #1

✓ answered by Rabbit

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

Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,357
You can use the DATEDIFF function to see how many months have elapsed between the current date and the date on the record.
Apr 16 '12 #2

P: 13
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?
Apr 16 '12 #3

P: 13
followed your advice and done :) thanks again
Apr 16 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.