Support DateTimeOffset as a DateTime in filters

Avatar
  • updated
  • Completed

 I'm looking to filter results for a date between X and Y



Instead for DateTimeOffset data type I have string - like filtering option.
No between and no date selector.



Instead I have a distinct value selector (and the two bottom buttons text are cuts)




Avatar
Anonymous

Hello,

Thank you for your question.

Fields of DateTimeOffset type are returned as WideString while using the OLE DB connection method and as DateTime while using the Native Client connection method. When data type of result column is Date, Time or DateTime, you can use the BETWEEN operator and see date selector.

The connection method can be changed in the Connection Properties dialog.