We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Crystal reports null values

KavyaVS
KavyaVS asked
on
Medium Priority
680 Views
Last Modified: 2012-05-11
I created a formula field in crystal  report.
I have one smallDatetime field in the data base.It can be either null or DateTime.If it is null I am displaying the string otherwise date time should be displayed.
If isnull({Cmd.LastActiveDate})Then
"Not Active"
else ({Cmd.LastActiveDate})=({Cmd.LastActiveDate})

else part is not working.It is giving error string is required here.
If it is null I am displaying the string.How to display the date if it is not null?

Thanks.
Comment
Watch Question

Author

Commented:
If isnull({Command.LastActivityDate})Then
"No Activity Since OpenDate"
else {Command.LastActivityDate}
I tried this also but giving the same error string is required here.
How to display the date if it is not null?

Thanks.
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
It is displaying the date as as 4/22/2011  12:00:00AM.
I want to format the field as 4/22/2011 ,but when I clicked the format field it is not giving the date time format option.
How to format it.

Thanks.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.