How to use date on External Search?

Hi @hhy38,

Please use date type in one of the below format.

YYYY-MM-DD
YYYY-MM-DD-HH24:MI:SS

If you are using IFS Application 9 UPD 7 or lower version you might need to upgrade the binary level as well.

Thanks and Regards,
Avindu Hendawitharana

Hi @Avindu Hendawitharana,

Thank you. But it didn’t work.

Regards,

Hasan

Hi @hhy38,

I had further checked and found that the data in the DATED column is stored in Date time format. So you want the correct data you might need to input detail with timestamp as well.

For me below executed without any issue.

ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=DATED=2011-10-04-15:42:26 

But it will not be a practical solution. Is there any other date column you can consider for the query like Transaction_date or date_applied. They only contain date values in the DB level and the search works without issue.

In above case you need to use below format

ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=DATE_APPLIED=20111004

Thanks and Regards,
Avindu Hendawitharana

The link throwed an error. If it is work on your app. I think there should be problem with region settings. Can you send your region settings? 

Hi @hhy38,

Please find the regional settings as below.

 

Thanks and Regards,
Avindu Hendawitharana

@Avindu Hendawitharana thank you for the effort. But it still not working. There is a different problem somewhere. If I can find it, I will inform you.

Regards,

Hasan