I had to do exactly just that. It was a sales order entry work flow,
and depending on the part number I had to subtract a day (or not), and
if the resultant day was a Sunday, move it back to the previous Friday.
There are algorithms out there for mathematically calculating the day of
the week for any day of any year. Message me offline if you want a copy
of that work flow to see how I did that. It wasn't simple, but it
worked pretty slick.
Rob Bucek
Manufacturing Engineer
PH: (715) 284-5376 ext 3111
FAX: (715)284-4084
<http://www.dsmfg.com/>
(Click the logo to view our site) <http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of foamdesigncsw
Sent: Friday, April 09, 2010 6:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] A way to do calculation in SC
I need a way to take a date in SC subtract 1 day but heres the tricky
part Sat and Sun dont count. So if my date is a monday i need to come up
with friday's date. Any Ideas on how i could do this?
~C
[Non-text portions of this message have been removed]
and depending on the part number I had to subtract a day (or not), and
if the resultant day was a Sunday, move it back to the previous Friday.
There are algorithms out there for mathematically calculating the day of
the week for any day of any year. Message me offline if you want a copy
of that work flow to see how I did that. It wasn't simple, but it
worked pretty slick.
Rob Bucek
Manufacturing Engineer
PH: (715) 284-5376 ext 3111
FAX: (715)284-4084
<http://www.dsmfg.com/>
(Click the logo to view our site) <http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of foamdesigncsw
Sent: Friday, April 09, 2010 6:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] A way to do calculation in SC
I need a way to take a date in SC subtract 1 day but heres the tricky
part Sat and Sun dont count. So if my date is a monday i need to come up
with friday's date. Any Ideas on how i could do this?
~C
[Non-text portions of this message have been removed]