on 2008 Nov 04 10:56 PM
Why is there no return value of "C" for records with nothing in this date field ? I am receiving no errors.
StringVar TagType;
If IsNull() Then TagType := "C"
Thanks ! ! !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. Are you sure there are null dates in your table?
2. See if under File | Report Options, the box next to 'Convert Database NULL values to default' is checked. If it is, then NULL values have been converted and that could be a reason why the IF statement seems as though it is not working.
3. Try altering your if statement to:
If IsNull() or = date(0,0,0)
Then TagType := "C"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raghavendra,
This did not work. is a date formatted column. The error message given is 'A date-time is required here.'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the formula editor at the top you can see a drop down list with values "Exception for nulls" and "Default values for nulls". Set this to "Default values for nulls" and try the following formula
StringVar TagType;
If ({Closing_Date})="" Then TagType := "C"
The formulas won't execute if the values are nulls.
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.