How to get the last two digits of the current year

[hemingt]

Hi Team,

I use the M language  Date.WeekOfYear(Date.From(DateTime.LocalNow()), Day.Monday) to get to the current week number, the value is 14 for today. But I want to get as 1914, is it possible?

if no, I think I can get the last two digits of the year, such as 2019, to get 19,  do you know how to do with M language?

Thank you!

[PattemManohar · Accepted solution]

@hemingt  Please try this as a Custom Column in Power Query to get the last two digits of the current year or any date field from the table.

=Text.End(Date.ToText(DateTime.Date(DateTime.LocalNow())),2)

[hemingt]

Thank you @PattemManohar