Concatenation of fields giving null as results

[isadoralmeida06]

Hello, guys.

I'm doing a simple concatenation: (01&'/'&Month&'/'&Year) AS Date, but it is giving me null as result.

Is there another way of doing such concatenation?

Thanks.

[lironbaram]

hi 

have you tried , 

makedate(Year,Month,1) as Date

[isadoralmeida06]

It gives me null results as well.