Report Designer Time format

I'm trying to create a formula for a date stamp time condition but cannot seem to figure out the format used for a time constant.

For example: Time Stamp > 14:30:00 doesn't work. What is the proper format for a time constant?

Parents Reply Children
  • 0 in reply to SamN

    I just tried and setup the conditions based on "Prompt fields" where the date is prefilled with the system date and the time is prefilled with the system time.  That way I could see the format for the time and in my test it was 14:30:00.  I think there can be a couple of ways you could format the prompt field for time, so using the prompt field formatted as time should help you figure out which is the correct format.