Date Format

[Anonymous]

Hi guys, 

I'm trying to format my date value.

I would like to have the date format as:

"YYYY-mm-dd"

Can somebody help me out with this novice question?

Thanks

[Pragati11]

Hi @Anonymous ,

You can change the date format outside Query Editor. Apply your query changes.

Under FIELDS pane click on your date column, then on the top ribbon you can find different date formats as shown below:

Thanks,

Pragati

[edhans · Accepted solution]

You don't "format" dates in Power Query. To convert that to just a date though, you would wrap the above with DateTime.Date, so :

DateTime.Date(DateTime.LocalNow())

That will strip the time component off.

If you are using that date field in a query that gets loaded into Power BI, that is where you can change the format of how the date looks. Select the Date field in the field listing after the data has loaded, then on the Column Tools menu, change the format, which doesn't affect the data, just how it is shown.