- Create a prompt on date column as per your requirement
- Expand Options and in Choice List Values option drop-down, select SQL Results and paste below Query ( Based on your Subject Area)
SELECT CURRENT_DATE FROM "Project - PRM and Time
Management"
UNION
SELECT TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE) FROM
"Project - PRM and Time Management"
UNION
SELECT TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE) FROM
"Project - PRM and Time Management"
Thanks,
Naveen
No comments:
Post a Comment