Results 1 to 2 of 2

Thread: Time expression

  1. #1
    Join Date
    Aug 2003

    Unanswered: Time expression

    I was wondering if anyone knew if it was possible to create an expression that filters the following:

    In a series of times, i want to find the latest time before noon and the earliest after noon.

    Any help would be greatly appreciated!

  2. #2
    Join Date
    Aug 2003

    Re: Time expression

    If you can create two more columns, the easiest way would be to create a column for times before noon and one for times afternoon. If you code and if statement in both columns to get the correct times in each, then you can use the max/min function to get the max before noon and the min after noon. let me know if you have any questions. You can even hide the extra columns if you dont want them visible.

Posting Permissions

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