I am getting an error with the DateSerial Function. I'm using the tabular query builder in MS Access. When I press RETURN in the field row, I get this: The expression you entered has a function containing the wrong number of arguments. Here is the text of my function:
CompMonth: DateSerial(YEAR(Date([Comp date])),MONTH(Date([Comp date])),1)
I marked this high priority because today is the last day my college programmer is with us. I'm trying to validate a page in the database dashboard by aggregating data to confirm that what I'm seeing is correct. If we have an error, we must fix today.