How do you use the Dayoftheweek variable?

[mudflap]

I am trying to make a formula that allows me to add up the sales for monday. Then copy that formula for each day of the week.

But I am unable to figure out the syntax for the day of the week variable.

Ie.

If (opendate) = dayoftheweek [2] then

Is this the correct syntax.
Opendate is field I use.
2 being monday.

Thanks
Peter

 

[Naith]

Hi Pete,

If DayOfWeek({OpenDate}) = 2
Then
...

Naith