nuBuilder Forum

Posted: **Fri Nov 27, 2020 6:11 pm**

I have dates in the format dd/mm/yyyy

If I include a date on a browse part of a form the search does not recognise the / character.

Date 23/11/1978

Search for 23 finds this. Similarly 11 and 1978 (or part of)

Search for 23/11 11/1 etc and nothing is found.

Posted: **Fri Nov 27, 2020 6:43 pm**

one of the solution:
if for example you Display value is: date
replace with:

Code: Select all

CONVERT(DATE_FORMAT(date, "%d/%l/%Y"), char)

and leave nuBuilder format blank for that field

nuBuilder Forum

browse not recognising /

browse not recognising /

Re: browse not recognising /