Weekend Data

[AGoodGuy]

I have a date field called Expiration date. Since I work on Monday - Friday, how would I be able to collect datat for Saturday and Sunday?

 

[SkipVought]

Hi,

How do you want to "collect"?

What are your criteria?

Generally you could use
[tt]
=if(left(text(YourDateRef,"ddd"),1)="S"),true,false)
[/tt]
where the text function "DDD" returns the day of week.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AGoodGuy]

I have the fieldname ExpDate set to Date()+32; which gives me the data for the policies with an expiration date of 11/18/2011. For expamle renewal offers goes out to customers with an expiration date of 11/18/2011 but the leeter went out yesterday being 10/16/2011. I would like to capture the data for Friday and Saturday. I do get the data for Dunday when I run the data on Monday because it is giving me the data the previuos day. I dont get the data for Friday nor Sataurday. How can I do that?

 

[bluedragon2]

Use the WEEKDAY formula to check for Monday and adjust your data pull to include the dates required.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...