Forum Discussion

jpapador's avatar
jpapador
Frequent Visitor
8 years ago
Solved

Only load dates where day = 1

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 edito...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

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