David Schmalzer
asked on
Check today's date
I have a vacation database (Modified Version of the Sandbox database). Anyway, I want to have a view which shows who is off Today. So, I would need it to look at the StartDate and the EndDate and determine if today's date falls between these dates(Start and End inclusive)and that the document has the Status of Approved.
ASKER
No, the 2 field names are StartDate and EndDate
@Today=(@TextToTime(@Text( StartDate) + "-" + @Text(EndDate)))
try that
try that
View selection formula should look like this..
Select @isMember( @text(@today); @text(@Explode( @TextToTime( @Text(start) + "-" + @Text(end) ) ) ) ) & Status = "Approved"
~Hemanth
Select @isMember( @text(@today); @text(@Explode( @TextToTime( @Text(start) + "-" + @Text(end) ) ) ) ) & Status = "Approved"
~Hemanth
ASKER
Ok, Heman that works. Now, suppose I want to email the Receptionist once a day using an Agent to email a list from the usernames in column 1 of this view(Sorted)? How would I do that? The view name is Today's Absent Employees. Added 75 more pts. since this doesn't exactly pertain to the original question.
ASKER
Should I post the second part as a new question?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I only want the agent to send 1 email at the scheduled time. I just did a test and it sent an email against every document in the view. That was 734 emails.
ASKER
To send just one document, I just made a dummy document and view with 1 saved document and just told the agent to act on that. Works fine. Thank you.
You could have also set the agent to be just a "run once" agent, in which case, you would not need the dummy document and view.
Assuming you are using CalendarDAtetime field. or get a list of dates in between and use that field