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 editor?

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

1 Reply

  • 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