I have a Notes field that logs the date of each entry. I would like to create a report that shows only the records that have a note from the previous 24 hours. Help!

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Kris


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Try this as a formula date/time field

var text DateAndTime = Left(Right([append only with date /time],"["),18);

var date TheDate = ToDate(Left($DateAndTime," "));

var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));

ToTimestamp ($TheDate, $TheTime)

Then make a formula date/time field field called [Now] with a formula of now() and use that to compare the date of the update with in our report filter.

It should give you the date/time of the update and you can compare that to eithjer bin a repwort filer to "