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

Discussion created by jayankurian on Apr 8, 2014
Latest reply on Apr 9, 2014 by Mike_Mitchell

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