Odata $filter Date Syntax

Hi,

OData provides Date and Time Functions that can be used in $filter expressions.

To retrieve specific parts of a date, you can use functions like day(), month(), year(), hour(), minute(), and second(). For example:

$filter=day(BirthDate) eq 8
$filter=month(BirthDate) eq 5

These functions allow you to extract data such as day,month from a given date field.

You can find more information about these Date and Time Functions in the OData documentation. Odata Documentation

IFS OData Provider currently does not support certain methods, and arithmetic operations are not permitted with properties of Date, Time, or DateTimeOffset. Please consult the IFS technical documentation for more details. IFS Documentation

You are able to work with the DayAfterMonth and CurrentDate variables because they are date attributes of CompanyPerson entity of EmployeesHandling. Odata allows you to compare and perform operations involving two date attributes within your OData queries.

Hi @PathLK Is there any  support to  arithmetic operations with properties of Date, Time, or DateTimeOffset with the latest Versions of IFS such as 24R1 etc.?

Hi, apologies for resurrecting this thread, but is there a way of calling sysdate at all on a lov filter ?

For instance, doing “ValidFrom le --today’s date--”

It doesn’t seem like I can call the “now()” syntax from oData filtering, is that an IFS limitation ?

I understand I could theoretically customize the lov to add an attribute of sysdate and then compare to that, but that’s a bit convoluted isn’t it?