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

Reply via email to