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.
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
browse not recognising /
-
Janusz
- nuBuilder Team
- Posts: 508
- Joined: Fri Dec 28, 2018 1:41 pm
- Location: Krakow, Poland
- Has thanked: 11 times
- Been thanked: 18 times
Re: browse not recognising /
one of the solution:
if for example you Display value is: date
replace with:
and leave nuBuilder format blank for that field
if for example you Display value is: date
replace with:
Code: Select all
CONVERT(DATE_FORMAT(date, "%d/%l/%Y"), char)If you like nuBuilder, please leave a review on SourceForge