Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    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 06:31. Reason: wrong date format type in

  2. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    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
  •