Only load dates where day = 1

[jpapador]

I have a list of dates in my source table, I would only like to pull in records where the day of the date is 1 (IE just pull in the first of the month records)  How can you do that in the query editor?

[MFelix · Accepted solution]

Hi @jpapador,

Add a custom column with the following sintax:

Date.Day ([Date])

Then filter it by day 1 and delete the custom colum:

Regards,

MFelix