PDA

View Full Version : Time expression

dumbgenius222
08-04-03, 10:40
hi,
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!
Thanks
Will
microgenius
08-20-03, 17:56
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.