Connection between two tables with different date format

[Peony]

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 .

[Vegar · Accepted solution]

You can convert TargetDate to your desired format like this.

Date(date#(TargetDate,'MMMYYYY'),'MM/DD/YYYY')

[Peony]

Thank you!