Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sushma RamakrishnanSushma Ramakrishnan 

Help regarding date formula field Today()

Hi All,

I have created a Formula Field with return type as 'Date' and have set the value as Today().To store the value of the date i create the record on.But i observe that when i create a record on current date it is auto updating the previously created record with current date/todays date instead of retaining yesterdays date for it/or the date on which it was created.

Thanks for Any Help in Advance...!!
Best Answer chosen by Sushma Ramakrishnan
sharathchandra thukkanisharathchandra thukkani
use DATEVALUE(CreatedDate), here CreatedDate is a system field and it is avilable with all the custom and standard objects.

If you want to use the CreatedDate as Date in reports it is already avilable for you, no need to create custom field again.

All Answers

sharathchandra thukkanisharathchandra thukkani
use DATEVALUE(CreatedDate), here CreatedDate is a system field and it is avilable with all the custom and standard objects.

If you want to use the CreatedDate as Date in reports it is already avilable for you, no need to create custom field again.
This was selected as the best answer
Ajay mishraAjay mishra
Hi Sushma,

Formula field is always calculated real time, so you can't store the value.

As your requirement need date on which the record is create. 

You can create Date field with the defualt Value Today(). 
Rakesh51Rakesh51
Can you post the formula here ? Mean time try this DATEVALUE(CreatedDate)
Sushma RamakrishnanSushma Ramakrishnan
Hi All,

Thanks so much for your time and patience and your valuable Suggestions...!
Instead of using Today() I made use of Standard Field - Created Date...!