Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: If Statement Post Reply Post New Topic
Author Message
knaylor
Newbie
Newbie
Avatar

Joined: 11 Aug 2010
Location: United States
Online Status: Offline
Posts: 1
Quote knaylor Replybullet Topic: If Statement
    Posted: 11 Aug 2010 at 6:26am
I am trying to use an if statement to say "If (a field = "NQ") then return a different date field else leave blank. I wrote the formula like this:

If({ROTPersonnelStatusTableB.Type}="NQ") then {ROTPersonnelStatusTableB.Expiration Date} else " "

but I am getting an error saying that I need to have a date in the "else" section. Does anyone know a way around this?


Edited by knaylor - 11 Aug 2010 at 6:26am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.