CODEWITHSUNDEEP
crystal-reportsformula
Dagz200
Dagz200

Reputation: 211

Suppress a DateString

I'm trying to suppress a formula field if it the date is greater for example 06/30/2013. I did a format field suppress formula {@DateString} > "06/30/2013" and still getting dates greater then 06/30/2013. Is there something that I'm missing that it might be because its a Date String.

Any help is greatly appreciated.

Upvotes: 0

Views: 353

Answers (2)

Ryan
Ryan

Reputation: 7287

In order to get this to work, you need to first convert the string into a date before doing any comparisons. So, date({@DateString}) > #06/30/2013# should get you what you're after.

Upvotes: 1

craig
craig

Reputation: 26262

Right click the field and select format field.... Select the General tab, then click the x+2 button to the right of the Suppress checkbox. Enter the following text:

CurrentFieldValue>#06/30/2013#

Upvotes: 0

Related Questions