browse not recognising /

Questions related to using nuBuilder Forte.

browse not recognising /

Unread postby GlenMcCabe » Sat Nov 28, 2020 2:41 am

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.
GlenMcCabe
 
Posts: 55
Joined: Sun Sep 29, 2019 8:10 pm

Re: browse not recognising /

Unread postby Janusz » Sat Nov 28, 2020 3:13 am

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
If you like nuBuilder, please leave a review on SourceForge
Janusz
nuBuilder Team
 
Posts: 446
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: No registered users and 9 guests