type datetime with zero time

[Bessonnizza]

Good day for everyone!

I try to change format of colomn on datetime in one row with AddColumn:

= Table.AddColumn(#"Переупорядоченные столбцы", "TodayDate", each Date.From(DateTime.LocalNow()), type datetime)

  I need column in format: dd.mm.yyyy hh:mm:ss, but PQ returns me dd.mm.yyyy.

Need	Have

Can somebody explain me, what am I doing wrong? If i write expression like this = Table.TransformColumnTypes(#"Добавлен пользовательский объект",{{"TodayDate", type datetime}}), all is ok, but i need write it in one row.

[edhans]

The following will return the start of the day. It won't be no time, it will be 12:00am, but that may depend on your localization settings as to how you visually see it.

=Date.StartOfDay(DateTime.LocalNow())

[Greg_Deckler · Accepted solution]

What about: = Table.AddColumn(#"Unpivoted Columns", "Custom", each DateTime.From(Date.From(DateTime.LocalNow())))