Date validation
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2024 03:50 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2024 05:35 AM
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