Connection between two tables with different date format
Please, could anyone gove an advise to finde the silution for the task below.
I have a two tables with different date type MM/DD/YYYY and MMMYYYY. I need to create common table with correspondence between these tables data. I suppose I need to convert TargetDate to MM/DD/YYYY . But I dont uderstent how to do it .