+ Start a Discussion
SFDC pvSFDC pv 

Hi, I want to check if the close date(date time field) is Greater than 6-Sep-2019 i need to trigger an email alert in workflow how can i check this with time stamp in workflow criteria . Please help

Rounak SharmaRounak Sharma
Hello,
You can try as
AND( ISCHANGED(CloseDate), CloseDate > IF(DAY(TODAY())>4, DATE(YEAR(TODAY()),MONTH(TODAY()),1), IF(MONTH(TODAY())=1, DATE(YEAR(TODAY())-1,12,1), DATE(YEAR(TODAY()),MONTH(TODAY())-1,1) ) ) )

This says that whenever the CloseDate is changed, it cannot be earlier than:

- The first of this month if today is after the 4th
- The first of December last year if today is in January
- The first of last month if today is not in January

Please let me know if it helps
Thanks
ankit tivariankit tivari
Hi! I must mention that I am satisfied with the information (https://www.alkhonjiholdingllc.com/investment) given in this post. Your post is really great