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
Calculate Dates based on Frequency 1
Frequency of date 4
Frequency of Billing 2
Create daily plan in Excel for tasks of weekly, monthly frequency 2
Table/query layout trouble 2
Conditionally populate a data table 2
Month, DATE, Week 7

Top