Skip to Content
0
Jun 25, 2020 at 08:09 PM

How do I compare a datepart to a whole number?

68 Views Last edit Jun 26, 2020 at 02:56 PM 2 rev

I'm writing a report based on year but I only have a period end date in the table. I have tried a comparison of datepart to an incoming parameter, I have tried rounding to do the comparison. I've tried totext. I know the fields I want to compare have the same number in them but when I add the date comparison I don't get any data back.