Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Unanswered: determine specific day

    I want to add the following to my form:

    today's date = thursday 2nd wk of the month = yes

    today's date = monday = yes

    today's date = tuesday 3rd wk of the month = yes

    i need help on this pls......tnx

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you can find the day of the week using one of the date functions (forget which.. may be datepart() may be weekday()).
    calculating whether its the first or second week of the month is fraught with difficulties, purely based on what rules you use to identify the nth week of the month.

    having found what todays date is (or arguably the first of the month you can then derive whatever values you require using dateadd() to generate a date in the future or past.

    depending on how complex your week/financial year is you may need to implement a working calendar which provides a method translating real world dates into the obscure and arcane calendar that only accountants want to understand.. the financial year calendar.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts