Sign Up ›
  • Enrique Pasos 8
  • NEWBIE
  • 10 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
5 replies

How do I report on past 24 hours

I want to pull a report showing new records created in the last 24 hours.  I tried using the following in a formula field (text) 

IF ( NOW() - CreatedDate < 1 ,"TRUE", "FALSE" )

But I get the error message 

"Error: Field CreatedDate may not be used in this type of formula"

Any help is appreciated.
SOLVED
5 replies

How do I report on past 24 hours

I want to pull a report showing new records created in the last 24 hours.  I tried using the following in a formula field (text) 

IF ( NOW() - CreatedDate < 1 ,"TRUE", "FALSE" )

But I get the error message 

"Error: Field CreatedDate may not be used in this type of formula"

Any help is appreciated.