Page 1 of 1

browse not recognising /

Unread postPosted: Sat Nov 28, 2020 2:41 am
by GlenMcCabe
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.

Re: browse not recognising /

Unread postPosted: Sat Nov 28, 2020 3:13 am
by Janusz
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 thatr field