LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  how to filter by month

    Employee
    Posted 10-17-2013 07:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dialpemo

    I have a csv file, one of the column contains dates, I have successfully converted to a date format however I want to filter by specific month and year, but so far I have to specify the day too. Please help


  • 2.  RE: how to filter by month

    Employee
    Posted 10-17-2013 08:18

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Assuming your field is named Revenue_Date, you could use this:

    where date(year(Revenue_Date),month(Revenue_Date),1) == date(2013,08,1)


  • 3.  RE: how to filter by month

    Employee
    Posted 10-17-2013 08:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dialpemo

    thank you stonysmith