Forum Discussion

Narender's avatar
Narender
Resolver I
8 years ago
Solved

Create date from year-month field

Hi All,   I have a field in yyyy-mm (like 2018-01) format.   I need to create this field to complete date dd-mm-yyyy (like 12-01-2018). days can be any.   Please suggest me.     Thanks,   ...
Need Help
  • Narender's avatar
    Narender
    8 years ago

    I did this in power query . Convert date type -> date.It has added 01 day with each yyyy-mm field.

     

     

    Narender

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

I'm wondering why you have to because if I enter values like this (using enter data)

 

The query editor changes this automatically to a datetime column

 

The formula for the automatic step will look like this:

= Table.TransformColumnTypes(Source,{{"DateIncomplete", type date}})

Wondering if this does not happen in your table

 

Regards

Tom