month function is giving the wrong month

[mordyb]

I have a query that pulls from a table with a date field called date. In the query I have another field that I want only the name of the month of the date field. When I use month([date]) the month is correct but only gives me the number. When I use format(month([date])."mmmm&quot it returns the month prior to the month of the date field. What am I doing wrong. TIA

 

[mordyb]

found my answer.