I currently have a Date field in the format of MM/DD/YYYY.
My goal here is to convert the Dates into 1 of 4 quarters, along with the Year. The field to be created will be called QTR_YR.
My first question is what data type do I need to make the QTR_YR field? Should it be Integer (Short or Long), or Date, or Double?
2nd, what will be the code - VBA or ArcPy? I am old school so I'd prefer VBA but I can go either way.
TIA for your help!Phil
أكثر...
My goal here is to convert the Dates into 1 of 4 quarters, along with the Year. The field to be created will be called QTR_YR.
My first question is what data type do I need to make the QTR_YR field? Should it be Integer (Short or Long), or Date, or Double?
2nd, what will be the code - VBA or ArcPy? I am old school so I'd prefer VBA but I can go either way.
TIA for your help!Phil
أكثر...