I have a large record set that contains several date columns. The date formats are MMYY, YYMMDD. and YMMDD (integer format). My requirements require that the above mentioned formats of these dates need to formatted to that of YYYYMMDD.
In addition it also a requirement that the MMYY date format be either the first of the month of last day of the month. What would be an efficient method of processing? Multiple data flows to handle each format? One data flow utilizing a lookup
to a calendar table? How would I handle if needed to add other date columns into the record set at a later time.
SQL - new guy
View Complete Post