var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Formula Help: Less than a Certain Time
I'm trying to filter a report by a certain time period. Basically I have a column for Activation Time. I want to see all data greater than two days old. Here's an example:
Today is January 3rd 2008. I want all Data Before January 1st 2008.
My activation time format is as follows: 1/2/2008 7:15:00AM
That is all in 1 field. The date and the time are not separate.
Is "1/2/2008 7:15:00AM" stored as a datetime value in your database?
What database are you using?
What version of CR?
I actually figured it out. I just used the CurrentDate function. This however returns True and False values that I will filter. I would love for it to just only show me the values greater than two but I can just use true or false filter.
Have you considered using the DateDif() function?