Filtering Records by Date Range in Syteline Form

I'm hoping you can assist me with filtering records in the Syteline Form. I'd like to be able to select records based on a specific date range.

For example, I'd like to filter records where the "Due Date" is greater than or equal to 10/15/2024 and less than or equal to 10/20/2024.

Could you please guide me on how we can filter in the Syteline Form?

Thank you for your time and assistance.

Find more posts tagged with

Syteline Development

Accepted answers

All comments

jkoch

What form are you trying to filter? You put this in the date field for due date greater than equal to >=10/15/2024

If you want filter between dates you would need to use the query form if there is one that exists for the form you are filtering on.

Prabakaran Nallayagounder

I am trying to filter the activity date in the "Customer Order Lines Change Log" form.

jkoch

Since there is no query form for the Customer Order Lines Change Log you cannot filter between dates. You could always create a dataview using the SLCoitemLogs IDO and filter that way

jennifer-foster

Not an exact answer, but may help you. You can try Date Filtering:

Date filtering */*/2023 – you can using the an * to filter on dates
- Ex: */*/2023 returns all data for 2023
- Ex: 1/*/2023 returns all data for January of 2023

Here are a few more you may find useful:

Filter on NULL <>NULL
- Ex: Enter NULL or <> NULL into a text field to search if that field is blank
Filter on check boxes

Ex: to filter on an empty check box, in filter mode, check the box, then uncheck and execute filter.

Underscore filtering

Ex: __4* (underscore, underscore, four, asterisk) will bring back everything with a 4 in the 3^rd digit

gnathan

Download SQLDataViewer and perform an SQL query.

Copyright © 2025 Infor. All rights reserved.