I have a control labeled txt_date which has the formatting value of a short date. txt_date is equal to another control which is bound to a database and is stored as text field. When i try to subtract date() - txt_date, i get a display with an error.
bound control = '3/2/2007' as text
unbound control txt_Date = 3/2/2007 as short date
this should work right?
If I recall correctly this function is possible since the control has a value formatted as a date. Why isn't it working?