Version 1.25 and earlier:


All TRIRIGA Platforms 3.7-4.x:

  • 'Equals' and 'Not Equals' Query filters are not functional on any date time formats
  • The following datetime format is not functional for any filter type for query filtering: 
    • dd-MM-yyyy HH'h'mm'min'
      • resolved in Version 1.26
  • The following formats work with 'Before', 'After', 'On and Before', 'On and After'
    1. dd-MM-yyyy HH'h'MM'min' 
    2. yyyy/MM/dd HH:mm a zzz 
    3. yyyy/MM/dd HH:mm zzz
    4. yyyy/MM/dd HH:mm a zzz
    5. dd/MM/yyyy HH'h'mm 
    6. dd/MM/yyyy HH:mm
    7. dd/MM/yyyy hh:mm a zzz
    8. dd/MM/yyyy HH:mm zzz
    9. dd/MM/yyyy HH:mm:ss
    10. dd/MM/yyyy hh:mm:ss a zzz
    11. MM/dd/yyyy HH:mm 
    12. MM/dd/yyyy hh:mm a zzz
    13. MM/dd/yyyy HH:mm zzz
    14. MM/dd/yyyy HH:mm:ss
    15. MM/dd/yyyy hh:mm:ss a zzz


Platform 4.0+:

  • Any date and date/time format beginning with the following do not work for any filter type
    • dd/MM/yyyy
    • yyyy/MM/dd