troubleshooting Question

What's wrong with this quarterly date formula?

Avatar of glabossi
glabossi asked on
Crystal Reports
8 Comments1 Solution268 ViewsLast Modified:
This formula was created by Frodoman back in July and I am just using it now.  But I am getting an error requiring a string after FALSE.  Can someone tell me where I went wrong?

If month(currentdate) = 4 then
  {MBRSUM.CREATE_DATE} & " in " & date(1,1,year(currentdate)) & " to " &  date(1,3,year(currentdate))
  If month(currentdate) = 7 then
     {MBRSUM.CREATE_DATE} & " in " & date(1,4,year(currentdate)) & " to " &  date(1,6,year(currentdate))
If month(currentdate) = 10 then
  {MBRSUM.CREATE_DATE} & " in " & date(1,7,year(currentdate)) & " to " &  date(1,9,year(currentdate))
  If month(currentdate) = 1 then
     {MBRSUM.CREATE_DATE} & " in " & date(1,10,year(currentdate)) & " to " &  date(1,12,year(currentdate))

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros