Year formula not recognizing 2016

[Former Member]

This formula is working for all years except 2016, for which Date Not Entered displays.  For some reason, it is not recognizing entries with a date of 2016.  Any idea why? 

If Isnull({PR.DATE_START}) then

      If Isnull({TW_V_SCHEDULED_START_DATE.DATE_TIME_VALUE})

      then "Date Not Entered"

      Else ToText(Year({TW_V_SCHEDULED_START_DATE.DATE_TIME_VALUE}),0,"")

Else ToText(Year({PR.DATE_START}),0,"")

[DellSC · Accepted solution]

Which version of Crystal are you using?

-Dell

[Former Member · Accepted solution]

Version 11 (XI)

[DellSC · Accepted solution]

If you go to Help>>About, what is the exact version number? 

Even though Crystal XI has been out of support for a number of years, there may be an update available that would help in this situation.  See here for more information: 

-Dell

[Former Member · Accepted solution]

Sorry for the brevity, Dell.  The full version is 11.5.10.1263. 

[DellSC · Accepted solution]

OK,  this is XI r2, which is good.  However, I think it may be an earlier SP.  You should look at the link I provided above to see about upgrading your version of Crystal to the latest service pack (SP6) that is available for XI r2.

-Dell

[Former Member · Accepted solution]

I think you're right that it's version related.  We are transitioning to v14.1.5.1501, so when I run the report in the new Crystal version, it pulls in 2016 as expected.  I've got a plan for a workaround until we launch.  Thank you for your help. 

[former_member292966]

Hi Linda,

Instead of using IsNull for a date, check it like:

If {PR.DATE_START} = Date (0, 0, 0) then

Do the same for your DateTime field.  This should get you better results. 

Good luck,

Brian

[Former Member]

I tried your suggestion, but it gave me a blank value instead of 2016. I think it's version related and the hazards of using outdated software.  Thankfully we're upgrading and it works in the new Crystal version.  I'll keep this in mind for future reports.  Thank you.