Page 1 of 1
Query Insert Selection Rule
Posted: Fri Sep 13, 2002 1:30 pm
by Typ0
I am trying to select records equal to a certain date. If I put a date in the compared to rule I get an error "date required". I also want to pass the date in from a ? user input. We have working reports like this. So I call the parameter "start" in the input file but if I put "start" in the compared to rule of the query I get error message "invalid value". I know my syntax is correct. I would like to know if anyone can lend some guidance as to why I can^t create a report from scratch like this? I have checked my regional settings. We are running windows XP and RR WINDOWS XBASE 8.1.
=> Query Insert Selection Rule
Posted: Fri Sep 13, 2002 3:06 pm
by kfleming
[updated:LAST EDITED ON Sep-13-02 AT 03:11 PM (EST)]If you are using an RIPARAM() calculated field, that will always return a character string.__So to compare it to a date field, you either need to create a calculated field using the DTOC function to convert the date to a character string or you need to convert the RIPARAM() string to a date using the CTOD function.____So a calc field with expression CTOD(RIPARAM("START") can be used in a filter comparing it to a date field.__NOTE THAT THERE NEEDS TO BE 2 ending parentheses after the "START"__when I try to add them to this message the forum software likes to make the first one a smiley face. But I do not want a smiley face (at least not in this message where I want 2 ending parentheses!)____Kathleen__R&R Support