Skip to Content
0
Former Member
Jul 02, 2007 at 10:11 PM

Getting last/previous billing date

14 Views

Hi,

My current program gets all data based on the default date (in my case, the previous day's date, such that if today is 7/2, the program would get all daily movement data based on 7/1.)

However, say the program is ran on a Monday. The program has to be smart enough to not get data for sunday, of which there would be none. It would have to get friday's daily movement data. How do we get the previous billing date?

Also, say a week has a holiday. In that case, we would needed data from Friday and Saturday, if the report was executed on monday.

Please help.

All responses will be appreciated and rewarded.

Thank You,

John