Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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 .
You can convert TargetDate to your desired format like this.
Date(date#(TargetDate,'MMMYYYY'),'MM/DD/YYYY')
You can convert TargetDate to your desired format like this.
Date(date#(TargetDate,'MMMYYYY'),'MM/DD/YYYY')
Thank you!