Frequency vs. Date

Q

QB

I have a db in which the user input a date and frequency. For example, April
4 2009 and weekly. I need to know based on the current date if that
condition is met, but am lost on how to approach this?

FYI - The frequency can be once, daily, weekly, monthly, quarterly and yearly.

I was looking at the datediff function but it only return whole numbers so I
can't use it to determine this? What method could I implement?

Thank you,

QB
 
Q

QB

Never mind.

After actually thinking for a moment I figured out I canused the DateDiff
and then Test the returned value using DateAdd to see if it matches up or not
with today.

Crude but effective.

QB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate weeks or months between dates 2
Frequency of Billing 2
Month, DATE, Week 7
How do I do a Quarterly reoccurring meeting in Outlook? 1
Date Based report 1
Using Combo Boxes as filter criteria 16
How to set payment dates and frequency? 1
Hiding formula to calculate % visits met 4

Top