The time that it records the comment against is held as a number. e.g 65642438

 

We convert that number to a date using this formula

 

cdatetime(round({sfcomments.amend-time}/86400,5)+32874)

 

I want to be able to select the comments made from 7am yesterday to 7am today (3 shifts) and run this report automatically, everyday at 8 oclock ready for our monring production meeting.

 

Is there a way of converting 7am today back to the number so i can say select comments between 7am yesterday and 7am today.

 

or is there a better way of doing what i need.

 

 

 

Much Appreciated