Year and Month field into a Date field

[fanninam]

I only have a field for Year and a field for Month.  I'm trying to turn it into a date.  Tried the following and it brings back 1/1/2009 instead of 11/1/2009.

Dual(MakeDate(T$FYEA),(T$FPER)) AS FullDate

[sunny_talwar · Accepted solution]

Try this

Date(MakeDate(T$FYEA, T$FPER)) as FullDate