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
  • 0

    Use the NEWDATE function to return a date that can be used for comparison. There is also a TIMEDIFF function, but that probably doesn't help you. Search the Help files in Report Designer for the proper format for use of these functions. 

  • 0 in reply to Art Minds

    Thanks,

    NEWDATE doesn't seem to work with time (as opposed to date) values. I tried using TIMEDIFF  but have the same problem, getting it to accept a constant time value. "Help" doesn't help much as far as that goes.

    I'm trying to filter for date/time stamps on transactions, (e.g.  DateStamp = 022319 AND TimeStamp > 14:30:00). The value for DateStamp is accepted but I can't get obvious format to work for the TimeStamp.

Reply
  • 0 in reply to Art Minds

    Thanks,

    NEWDATE doesn't seem to work with time (as opposed to date) values. I tried using TIMEDIFF  but have the same problem, getting it to accept a constant time value. "Help" doesn't help much as far as that goes.

    I'm trying to filter for date/time stamps on transactions, (e.g.  DateStamp = 022319 AND TimeStamp > 14:30:00). The value for DateStamp is accepted but I can't get obvious format to work for the TimeStamp.

Children