[12.2.387 Pro] - Custom Filter

[12.2.387 Pro] - Custom Filter

I want to filter in a result set tab on a column that contains DATETIME2 values. However, when I try to add a custom filter, and I copy the value from a cell in that column to add to the custom filter, I get an error message:

	Quote:
	'2023-04-12 03:23:39.518' is not a valid date and time

It's a bit weird, the Custom filter dialog depends on local settings and wants dates and times entered in your system local date/time format, usually dd/mm/yyyy... or mm/dd/yyyyy... which might be different from the format in which they appear in grids.

I'm sorry i take it back. It does take local datetime format but I'm unable to make it match the values. I'm going to submit this case and ask for help.

	SysOp wrote:
	It's a bit weird, the Custom filter dialog depends on local settings and wants dates and times entered in your system local date/time format, usually dd/mm/yyyy... or mm/dd/yyyyy... which might be different from the format in which they appear in grids.

It would be nice if it accepted any obscure local date and time formats the system might be set, but I'd thought it would accept those in addition to "normally" used formats, not instead of them. I also expected it to accept datetime in ISO 8601 format.

Our internal investigation uncovered that filtering for datetime values using custom filters isn't working correctly. There are actually couple of different issues. Developers think they can fix it in time for 12.3 release which we expect in 2 to 3 weeks if it goes as planned.

That's good news!

I need some additional help. Can you tell me where/how to check the expiry date for my license/maintenance? I guess it has already expired but I cannot find the last mail with the license key. I've saved the key but forgot to add the expiry date to my calendar.

Please email to support, they can help with that