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!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
browse not recognising /
-
Janusz
- nuBuilder Team
- Posts: 506
- Joined: Fri Dec 28, 2018 1:41 pm
- Location: Krakow, Poland
- Has thanked: 8 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