Function to determine working day

[rtipton12]

Hello all.

I have a program that needs to be run on the 5th working day of each month. Is there a function that will tell me which working day I am on?

Any ideas are appreciated.

Thanks.
Rt

 

[ramani]

One is probably SUNDAYS. Then there can be public holidays.

IF DOW(DATE()) = 1 then it is SUNDAY.
my5thWorkingDay = DATE() - ;
DAY(DATE()) + 5 + IIF(DOW(DATE()-DAY(DATE())+5)<5,1,0)
+ No.ofPublic Holidays



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[rgbean]

You may want to check out this article - "Calculates the Number of Business Days and Excludes Holidays/Weekends" at

http://support.microsoft.com/?id=259772.

Rick

 

[Mike Lewis]

Rt,

In addition to the good advice you have been given, if you would like some help with determining the dates of holidays, see:

http://www.ml-consult.demon.co.uk/foxst-10.htm

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[rtipton12]

Thank you all for your help.

rt