Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Sheffield, Yorkshire
    Thanked 0 Times in 0 Posts

    Last Working Day

    I have created a simple query for a report, which displays all the results I need. What I want to do, is for the query to show the last working days figures, so if I run the report Tuesday, I get Mondays figures, if run Monday, I get Fridays figures. The original field in the query, was a long date/time. To get just the date, I have entered Date: Format([ustadate],"dd/mm/yy").
    Last edited by robm; 2012-07-06 at 05:31. Reason: wrong date format type in

  2. #2
    Join Date
    Feb 2011
    Thanked 6 Times in 6 Posts
    What is supposed to happen on Tuesday if the day before was a public holiday? If you want to cater for non work weekdays, you will need a lookup table of public holidays and the exercise is not a trivial one, do-able but I'd be using VBA to get the date of the previous work day.

Posting Permissions

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