greater/less than for dates in m language

Todd77

New Member
Joined
Aug 20, 2019
Messages
12
Hi all,

I'm trying to create a column in power query editor that looks at a date and inserts 'exclude' if it's after 1Apr2020 and inserts 'include' otherwise. The editor, however, says using <= or >= doesn't work for dates. What expression should I use instead?

Todd
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,095,352
Messages
5,443,959
Members
405,257
Latest member
daveyf

This Week's Hot Topics

Top