I am trying to convet an incoming Date('mm/dd/yy') in Varchar format to Date ('yyyy-mm-dd').
I have used the following function in transformer.
If IsNull(LNK_XFRM_REAL_EST_STORES_DM.store_open_dt) Then SetNull() Else StringToDate(LNK_XFRM_REAL_EST_STORES_DM.store_open_dt,"%mm/%dd/%yy") .
And I am getting the error :
main_program: Fatal Error: Added field has duplicate identifier():
Any idea what might be the problem.
![Shocked :shock:](./images/smilies/icon_eek.gif)