Results 1 to 3 of 3
  1. #1
    Milgrl3 is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2016
    Posts
    5

    default value for upcoming friday

    Hello!
    I have built a web app for work and in one of the fields, "Week Of", I want to have the upcoming Friday as the default value, but having trouble building an expression to do so. Any help would be appreciated! Thanks!

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    look at using the weekday function (google it) this returns the day of the week as a number - depending on the default start of week. This can then be added to date() to give you Friday's date

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    As ajax said

    If week starts with Sunday, then Friday is Day 6,

    Date + 6-(weekday(date)) is probably the next Friday

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Setting upcoming Friday as default value
    By Milgrl3 in forum Access
    Replies: 6
    Last Post: 03-10-2016, 03:55 PM
  2. Upcoming Holidays Alert
    By hicham6w in forum Programming
    Replies: 3
    Last Post: 05-20-2015, 06:37 AM
  3. Calculate last 4 weeks (Friday to Friday)
    By Astron2012 in forum Queries
    Replies: 2
    Last Post: 11-29-2013, 04:08 PM
  4. Field to display last Friday's date by default
    By lsmcal1984 in forum Forms
    Replies: 11
    Last Post: 10-07-2013, 12:05 PM
  5. Query for upcoming expiration date
    By jones in forum Queries
    Replies: 2
    Last Post: 05-16-2012, 02:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums