Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    17

    Unanswered: Formula Help: Less than a Certain Time

    Hey guys,

    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.

    Any advice?

    Thanks,

    Paul

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is "1/2/2008 7:15:00AM" stored as a datetime value in your database?
    What database are you using?
    What version of CR?
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    17
    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.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Have you considered using the DateDif() function?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •