Summer '26 (API version 67.0)
To combine the year, month, and day into a value that’s called CreatedDate:
q = foreach q generate Id as Id, Year + "-" + Month + "-" + Day as CreatedDate;