Writing Expressions Involving Time

[christopherlee2]

I'm trying to write an expression using the time portion of a timestamp.  The format of the timestamp is yyyy-mm-dd hh:mm:ss.  I'm trying to write a formula to return 'True' if the time is after 6:00.   What is the best way to do this?  Do I need to trim the time portion out of the time stamp?  Thanks!

[jdunkerley79 · Accepted solution]

Easiest is probably just to do:

RIGHT([Time], 8) >= '06:00:00'

[christopherlee2]

Thanks, easy enough!