Looking to get advice on how to create a datetime field by combining int year and month fields with a '05' for the date. I'm trying this in my query for the field:
Cast(Convert(nvarchar,(ib.InvoiceAccountingYear + '-' + ib.InvoiceAccountingMonth + '-' + '05'))AS smalldatetime) AS FirstInvDt
but it's returning dates such as these, with an 01 as the date part:
Any recommendations on how I can get the dates to appear with an '05'? Thanks in advance for your insight!