[progress Communities] [progress Openedge Abl] Forum Post: Re: Filter By Date Field For...

[Charles Ford]

We still have this issue whereby searching on a Date field causes Rollbase to create a query string with the incorrect format separators and prevents any search data being returned, alternative query.log example: SELECT COUNT(A.OBJ_ID) FROM RB_OBJ_DATA A WHERE A.OBJ_DEF_ID=5707140 AND A.DATE1>=STR_TO_DATE('01 . 01 . 2018', '%m/%d/%Y') AND A.DATE1<STR_TO_DATE('01 . 01 . 2019', '%m/%d/%Y') Regards -- Charles

Continue reading...