End of Month in M

[Anonymous]

hello, 

i'm trying to automate the following code in M 

= Table.SelectRows(#"Changed Type2", each [DateEoM] <= "2021-06-30")

with [DateEoM] a date table which has all end of moth date

what i want to do is a variable with take automatically the EOM date instead of me writing it like i did here "2021-06-30"

sommeone knows how to do it please ?

[CNENFRNL · Accepted solution]

Date.EndOfMonth(dateTime as any)