Joel, Is your variable venrolldate is set to #date in the form or prior to opening the form? This is what I would do:
1. In an on before start eep SET VAR venrolldate = .#date 2. Place your venrolldate variable date picker on the form. 3. No need to use getproperty. If the user changes the date in the date picker, venrolldate will now be whatever the user picks. On your bit button eep do your update - UPDATE StudentMaster SET Stu_EnrollmentDte = .venrolldate WHERE Stu_number = .vnumber By the way, I believe the getproperty <componentid> showtoday returns a value of true or false, not a date. I'm not sure I understand how you've got everything set up, so if this doesn't work how you want, please reply back. Dawn -----Original Message----- From: Joel Solomon [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 11:10 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Variable Date Picker Good Morning, I have a variable date picker in my form that defaults to #date. When I change the date to another date, I want to save this date a corresponding column in the table. Below is what I have done so far. 1. Put a variable date picker in my form. The variable name is VENROLLDATE and this variable is set to #DATE. The component ID is edenroll. 2. I have a bit button to save the record and then: GETPROPERTY edenroll SHOWTODAY .venrolldate UPDATE StudentMaster SET Stu_EnrollmentDte = .venrolldate WHERE Stu_number = .vnumber When I look at the record, Stu_EnrollmentDte has the default date rather then the new date I entered in the form. What am I doing wrong? Joel Solomon V.P. Finance Barbizon International [EMAIL PROTECTED]
