Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, November 22, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Controls | New ThreadView:  Search:  
 Author  Thread: How to set the date conditions for the lookupedit control?
william xie
Posts: 28
 
How to set the date conditions for the lookupedit control?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Sep 06 7:51 PM
fiogf49gjkf0d
In my lookupedit control, the lookup restrict condition is: the start date greater than today.

Then I set: RestrictField is: startDate, RestrictOpt is: >, RestrictValue is: getdate().

It does not work. Is there anything wrong with it?
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: How to set the date conditions for the lookupedit control?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Sep 06 8:09 PM
fiogf49gjkf0d
IIRC the RestrictValue will get wrapped as a string when it all executes. Try placing the literal date value in instead at runtime.

ie:
lookupedit1.RestrictValue = Now()


Or you could play around with something like:

RestrictOp = " > getdate() and '1' = "
RestrictValue = "1"

-Ryan
[Reply][Quote]
Bob (RJ)Ledger
Posts: 1103
Top 10 forum poster: 1103 posts
 
Re: How to set the date conditions for the lookupedit control?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Sep 06 8:51 PM
fiogf49gjkf0d
...also adding a "space" here and there helps a lot!
--
rjl
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/22/2024 8:08:07 PM