Creating Date Range in Pivot Microsoft Query
 

I have a pivot that I've connected to our SQL db using the MS Query. I'm
having two problems with it:

1. In Access I create a date range to see dates between 3 and 15months ago
with the SQL statement "
WHERE (Trx.TrxDate) Between (Date()-485) AND (Date()-120)"
- no problem in Access but not the MS Query program. When I do it through
the Excel MS Query it says the Function 'date' is not valid. How do I
describe the current date in the MS Query program?

2. In the same wizard I cannot combine two fields (in Access I would use
Expr1: [Field1]&", "&[Field2]. Is there a place to do this in MS Query?

Thanks Ian.