I wanted to use castmonth to filter the data to only show data for 06 which is june. However, the castmonth column has values like 201106, 201107 (a combination of year and month)
Please help, thank you.
FROM [Opt].[EDA4010].[I_DETAIL] as invoice_detail
join [Opt].[EDA4010].[CONTRACT] as contract
on [contract].[CNUMBER]=[I_DETAIL]. [CNUMBER]