Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Date(MakeDate(T$FYEA, T$FPER)) as FullDate