This content has been marked as final. Show 11 replies
I am getting this error whenever I try to load my Master Calendar for our Fiscal Year.
"Cannot find field"
Here is what my script looks like:
FROM [lib://Q-CCM (tbh_erickd)]
(XmlSimple, table is [Envelope/Body/ExportDataSetResponse/ExportDataSetResult/diffgram/NewDataSet/Table]);
// Master Calendar for fiscal year
Load Dual(fYear-1 &'/'& fYear, fYear) AS FYear,
Dual(Month, fMonth) AS FMonth,
Load Year + IF(Month>=$(vFM), 1,0) As fYear,
Mod(Month-$(vFM),12)+1 As fMonth,
Year(Visitdate) As Year,
Month(Visitdate) as Month,
Week(Visitdate) as Week,
From Resident CCM;
I apologize if this is elementary stuff, I have looked over the information here on the forum but it hasn't clicked just yet.
Any wisdom would be greatly appreciated!