Post

2 followers Follow
0
Avatar

Time Sheet Valatation Rule

Want to create a validation rule that will not allow time sheets to be entered for a closed month.  Would like the cut off to be the 2nd of the current month.  Will only allow admins to post time in past months.

 

it Answered

Please sign in to leave a comment.

1 comment
Date Votes

0
Avatar

Hi,

If I understand your requirements correctly, I think that something like this would work:

(Month($ReportedDate) < Month(OrganizationNow()) || Month(OrganizationNow()) = 1 && Month($ReportedDate) = 12) &&
Day(OrganizationNow()) > 1 &&
$ReportedDate < OrganizationNow()

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink