How can i search or Filter by Date AND time in a Date/Time field

Hi ​@QHFJESP,

Records can only be filter with Dates, however, with Advance search, business users can filter records with Date and Time.

Please refer to the below screenshot.

Regards

Abdul Rehman

Hi ​@QHFJESP,

Records can only be filter with Dates, however, with Advance search, business users can filter records with Date and Time.

Please refer to the below screenshot.

 

Regards

Abdul Rehman

that's a bummer, but i really appreciate your response Abdul, we will try to use the Advance filtering.. Thank you!!

hello,

​@Abdulm thank you for the response.

I tried to find transactions created at 4:58 pm and it turned out that it did not take seconds into account

So the only solution is those, you proposed and use:

DateTimeMinuteCreated >= 2026-01-28T16:58:00Z AND DateTimeMinuteCreated <= 2026-01-28T16:58:59Z

Edited:

we are in 25R1 which introduced time zones.

When Seach with Time Zone is selected, then you can put the following and it gives you results: 

Regards,

Kajetan

hello,

​@Abdulm thank you for the response.

I tried to find transactions created at 4:58 pm and it turned out that it did not take seconds into account

 

So the only solution is those, you proposed and use:

DateTimeMinuteCreated >= 2026-01-28T16:58:00Z AND DateTimeMinuteCreated <= 2026-01-28T16:58:59Z

 

Edited:

we are in 25R1 which introduced time zones.

When Seach with Time Zone is selected, then you can put the following and it gives you results: 

 

 

 

Regards,

Kajetan

Hello ​@Guzik , just to make sure i understand, where you able to search by Date and time in the inventory transaction history screen, without using the advance search??

when i try it myself, i only see a Date picker, not a Time picker, im in 24R2.

hello ​@QHFJESP ,

Correct, there is only a date picker, but I typed time manually in that field.

I just copied value from the column and added the last part that are seconds:

28.01.2026, 16:58:00

I can see your date format is M/DD/YY H:MM AM/PM

I am not sure it if works but I would select “Search with time zone” and try e.g. 1/12/26 2:26:00 PM

just as a tip:

add site to search criteria BUT with equal sign, it makes your search much faster:

regards,

Kajetan

hello ​@QHFJESP ,

Correct, there is only a date picker, but I typed time manually in that field.

I just copied value from the column and added the last part that are seconds:

28.01.2026, 16:58:00

 

I can see your date format is M/DD/YY H:MM AM/PM

I am not sure it if works but I would select “Search with time zone” and try e.g. 1/12/26 2:26:00 PM

 

just as a tip:

add site to search criteria BUT with equal sign, it makes your search much faster:

 

 

 

regards,

 

Kajetan

​@Guzik  i really appreciate your response, i was able to use it as you described.. that gives me another option.

Thank you again!!!!

Hi ​@QHFJESP,

Records can only be filter with Dates, however, with Advance search, business users can filter records with Date and Time.

Please refer to the below screenshot.

 

Regards

Abdul Rehman

This seems contradictory to what the documentation says Date Time Picker - Technical Documentation For IFS Cloud

...or its boundaries just aren’t well defined

You can show a datetime picker in a dialog... using a structure is the only way that it is allowed I guess??
 

What is the reason behind this MAJOR limitation? Any roadmap for enabling this?