Suggest a Rule pls

Rennur

Can anyone suggest a RULE to check if a DAY within a range of 2 Timestamps has a SUNDAY as DAY_OF_WEEK in it.

Cheers

customaware

This might help Rennur.

I am not sure how to get the INT of a number in Aware and a 2 am I am not going to keep searching tonight...however....

I think this is getting pretty close except for cases of less than a week. It will count the number of Sundays between 2 dates.

DemoData.NumberSundays=(DAY_DIFFERENCE(DemoData.SecondDate,DATE_ADD(DemoData.FirstDate,7-DAY_NUMBER_IN_WEEK(DemoData.FirstDate)+1))+1)/7+1

Should be in the form....

DemoData.NumberSundays=INT((DAY_DIFFERENCE(DemoData.SecondDate,DATE_ADD(DemoData.FirstDate,7-DAY_NUMBER_IN_WEEK(DemoData.FirstDate)+1))+1)/7)+1

Still need to do some further testing but might be a start.

Rennur

It will count the number of Sundays between 2 dates.
DemoData.NumberSundays=(DAY_DIFFERENCE(DemoData.SecondDate,DATE_ADD(DemoData.FirstDate,7-DAY_NUMBER_IN_WEEK(DemoData.FirstDate)+1))+1)/7+1

Wow. All of that? :lol:

customaware

Sorry Rennur,

I have not had a chance to get back to this.

Did you get it to work?

Rennur

I haven't tried yet. It's not clear to me what is happening in that rule.