I have 4 date parameters in a BAQ that I am trying to compare to the InvcHead.InvoiceDate and it gives me an error when I check syntax

R.Zimmer · September 12, 2024, 8:53pm

I must be doing something really stupid. Please help!

Thanks,
Richard

Banderson · September 12, 2024, 8:56pm

Where is {CurrentYrFrom} coming from? The correct syntax for a parameter is @parameter

utaylor · September 12, 2024, 8:56pm

The good ol days of 9.

Banderson · September 12, 2024, 9:00pm

Ah crap. I saw your version on your name as 10.2, so I didn’t realize you posted this in the 9 topic.

Never mind, I don’t know what I’m talking about with 9.

utaylor · September 12, 2024, 9:05pm

what type is “CurrYearFrom”

R.Zimmer · September 12, 2024, 9:11pm

Sorry, I am in E9. {CurrentYrFrom} is a date parameter field. I select it from the parameters list when I am in the Calculated fields and it puts {} around it. The @parameter is not correct in E9.

utaylor · September 13, 2024, 12:52pm

It’s either InvoiceDate is Datetime and the curyear is date type (or some other type that’s not compatible with InvoiceDate date type) and that might be causing a problem or the 0 needs to be converted to a decimal to match the data type of ExtPrice.

0 is integer I think?

@R.Zimmer can you show me the calculated field screen for the {CurrentYrFrom}?

utaylor · September 13, 2024, 1:02pm

Also, I just don’t know why you are making the type of the calculated field {curyear} a date type… The current year is an integer typically. {Today} would be a date.

If you’re trying to see if the year of the invoice date is equal to the current year then you need to extract the year from the invoice date and compare that to the {curYr} field you have.