[Question] Does OData $orderby support working with Edm.Date or DateOnly fields?

[AndriiLesiuk]

Is it possible to make the OData $orderby function work with Edm.Date or DateOnly fields?
It currently only works with DateTime fields.
I didn't raise this question on "Discussions" because there it takes a long time to wait for an answer, for which I apologize.
I would be grateful for any example or advice.

[aboryczko]

I have an Edm.Date field in one of my models and $orderby works properly. The field is a DateTime field in .NET. When I was working on it a year ago there was no support for DateOnly in this library.

I would have answer it also in Discussions because I check both 😉

[AndriiLesiuk]

I have an Edm.Date field in one of my models and $orderby works properly. The field is a DateTime field in .NET. When I was working on it a year ago there was no support for DateOnly in this library.

I would have answer it also in Discussions because I check both 😉

What EF provider and database did you use in your project that worked with Edm.Date?

[AndriiLesiuk]

I use Postgres and the libraries for it:

[aboryczko]

EF Core 6 and Microsoft SQL Server 2019, but like I said the .NET object has a DateTime field (it didn't work with any other type)
public DateTime VerifiedOn { get; set; }
and in the model I have
entity.Property(x => x.VerifiedOn).AsDate();

[AndriiLesiuk]

@aboryczko
Sorry to bother you again, but unfortunately my problem has not gone away.
It's not possible to use /odata/Entity?$orderby=date(where date is DateTime with AsDate())
I tried a few ways:

1. Add ColumnAttribute:
   

2. Add AsDate in model builder:
   

And I still getting this error:

I found this all happening in the LiteralFormatter class(Microsoft.OData.Core).
Here we have such section, which is ignored:

and then it just go to

Do you have any ideas?
Big thanks.

[AndriiLesiuk]

I tried almost everything on here but it didn't help.
link

[xuzhg]

I tried almost everything on here but it didn't help. link

Can you create a 'value' converter 'https://github.com/OData/odata.net/blob/master/src/Microsoft.OData.Core/ODataPayloadValueConverter.cs' and use it in your project?

[AndriiLesiuk]

I tried almost everything on here but it didn't help. link

Can you create a 'value' converter 'https://github.com/OData/odata.net/blob/master/src/Microsoft.OData.Core/ODataPayloadValueConverter.cs' and use it in your project?

Converter works:

, but this will change all DateTime fields in my project.
Instead, I need to change only some of them that are of type DateTime.

When I try something like this:

, it still fails any of the type checks in the FormatRawLiteral(object value) function.

I expected the value to go into this section of code, but for some reason it doesn't work.

Also parameters that are passed to ConvertToPayloadValue(object value, IEdmTypeReference edmTypeReference) to write at least some primitive check in order to limit this functionality for certain fields.

Is it even possible to do anything else?