on 08-28-2009 10:39 PM
Hi All,
Can toText() be used to convert a date parameter field to string type?
When I use a ToText({?dateRegistered}) in an if case
if ToText({?dateRegistered}) = "" -? throws an error saying a number, date, or date time etc... is needed..
Please guide
thanks for you time.
Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you should be able to run this formula
if ToText({?dateRegistered}) = "" then 0 else 1
did you enter any date value in the parameter? if the parameter value is null then try to select the option "default values for null" option in the formula editor and check the formula
regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is your parameter is a date parameter? if so are you trying to run the report with date value =""?
Usually if you create any static date parameter then use default value as 1901-1-1 and try this fromula
if {?date parameter}=date("1/1/1901") then
true
else
{date field}={?date parameter}
Are you using date range parameter with start date and end date?
regards,
Raghavendra
Got it. If you are not using start date and end date then you might be using multi value parameter. If you are using multi value parameter you need to mention the index value of each item like an array. for example
if totext({?date parameter} [1]) = "" then true
else
in {?date parameter}
this example checks the first value is "" or not
regards,
raghavendra
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.