Date Formual to return Specific date of the Week

[luvmy2kids]

I have the below formual:

If DayOfWeek({Command.weekending}) = 2 Then
{Command.weekending}-6

I am trying to return a date of:

2009/8/17, but it returns nothing? weekending is a datetime field, does that matter?

Please help!!

 

[luvmy2kids]

I figured out the reason I am not getting any data is becuase the date of "weekending" is 8-23-2009 which is a Sunday. So what I need to do is just get the day of the week and based on that day, then do my subtraction from the weekending to get it to display the correct date? Any suggestions?

Thanks a bunch!!

 

[luvmy2kids]

Got it~ nevermind!!

Thanks!

 

[lbass]

Please explain your solution so others can benefit.

-LB