Hi gang,
I need a bailout.
I have a fields called "sys_first_day_of_week" and the user can select
one value which will be from a menu with these options:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Based on this "Preference" and TODAYS DATE, I want to calculate the
first day of the week.
So if my preference is "Monday" and Today's date is 10/19/2010, I want
to return a value of: 1287374400 (which is 10/18/2010)
if my preference is "Wednesday" and Today's date is 10/19/2010, I want
to return a value of: 1286942400 (which is 10/13/2010)
Appreciate any help.
Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
donw@xxxxxxxxxxxxxxxxxx
Direct Line - (949) 336-4828
Integrated data solutions to fit your business needs.
Need assistance in dialing in your FileMaker solution? Check out our
Developer Support Plan at:
http://www.dwdataconcepts.com/DevSup.html
Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro
9 or higher
http://www.appointment10.com
For a quick overview -
http://www.appointment10.com/Appt10_Promo/Overview.html
