Calculation Madness Again

  • Thread starter Thread starter jsd
  • Start date Start date
J

jsd

So close but so far away! Thanks for the reply!

I was in need of a calculation for an invoice report I'm
designing. The following expression was not rejected,
although I'm prompted that there is an extra )??? I've
tried to play with the calculation but can't seem to
figure out where.

Help...

DateSerial(Year(Date(), Month([Effective Date]), Day
([Effective Date])& " to " & DateSerial(Year(Date() + 1,
Month([Effective Date]), Day([Effective Date]) - 1)
 
I think i see your proble
DateSerial(Year(Date(), Month([Effective Date]), Da
([Effective Date])& " to " & DateSerial(Year(Date() + 1,
Month([Effective Date]), Day([Effective Date]) - 1
You aren't closing your initial set of paranthesis. (Year and (Date have no close the first time and (year the second time isnt closed either. You only have one ) at the very end for too many open ()


----- jsd wrote: ----

So close but so far away! Thanks for the reply!

I was in need of a calculation for an invoice report I'm
designing. The following expression was not rejected,
although I'm prompted that there is an extra )??? I've
tried to play with the calculation but can't seem to
figure out where

Help..

DateSerial(Year(Date(), Month([Effective Date]), Da
([Effective Date])& " to " & DateSerial(Year(Date() + 1,
Month([Effective Date]), Day([Effective Date]) - 1
 
I've highlighted the three closing parentheses you're missing as _)_

DateSerial(Year(Date() _)_ , Month([Effective Date]), Day
([Effective Date]) _)_ & " to " & DateSerial(Year(Date() _)_ + 1,
Month([Effective Date]), Day([Effective Date]) - 1)
 
Back
Top