Create Date column (DD / MM / YYYY) from AnoMês column (YYYY / MM)

[pbjungles]

Good afternoon,

I need to create a column (Dimension) DD / MM / YYYY, but the basis that I have only exists AnoMês (YYYY / MM).

For the project I'm doing no matter the date, and thus can always be 01.

As I have today.

AnoMes.png

I need the following format: DD / MM / YYYY Example: 01/02/2016 ... 03/01/2016 ... 04/01/2016

Thanks for the help.

[sunny_talwar · Accepted solution]

May be like this

Date(MonthStart(Date#(anomes, 'YYYYMM')), 'DD/MM/YYYY') as anomes

[Frank_Hartmann]

see attached sample

hope this helps!

[maxgro]

date(makedate(left(AnoMês,4), Right(AnoMês,2)), 'DD/MM/YYYY')

[silambarasan]

use

MakeDate() and left & Right  function