9 Replies Latest reply on Apr 9, 2014 7:41 AM by Mike_Mitchell

    How do I find next day's group of records skipping Saturday and Sunday?


      Hi all,


      I am trying to create a button for the user to click and find/display next day's records, my DB contain only week days dated records no weekend dated records.

      I created a simple script which can find records from Monday thru Frinday, but I dont know the script step that skip Saturday and Sunday and find following Monday's record while users are in Fridays records.


      Fields in my DB

      Date of appointment - Name - Procedure - Phone Number

      No Weekend records (only M-F records).


      This is what I wrote and it works for Mon thru Fri


      Go to Layout[Layout Name]

      Go to Field [Date field]

      Copy [Selelct Date field]

      Enter Find Mode[]

      Paste[into the Date field]

      Set Field [Date field + 1]

      Perform Find[]


      Appreciate any help...


      Thank you