Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Date validation

Supriya P
Tera Contributor

In pm_project table,

1. How to check current date is 30 days greater than project start date.

2. There should be a minimum of 5 recourse plans tagged to Project.

 

1 REPLY 1

Mark Manders
Giga Patron

You can just query on your list: start time 'relative' 30 days before now.

And you can run a report on project where you add a related list condition on the resource plan related list for 'less than 5' to get the projects that have less.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark