Difference between TODAY() and NOW() in Salesforce?

If TODAY() Doesn’t work try using NOW() instead.
The difference is NOW() returns a datetime while TODAY() only returns a date.
You should convert before using both, like below
DATEVALUE(Due_Date) – TODAY().

Ex:
TODAY() – 2013-02-10
NOW() –  2013-02-10 01:30:45 AM

Written by 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 5x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply