You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.
  • I have this
    Access SQL

    WHERE [Date entered] Between #1/1/2016# AND #31/12/2018#
    

    I take an extract (wait come back) and it's not always on a fixed day.
    What it should have in it is all data from 2016 - end of the last month.
    So in feb it should look at Jan. March should look at feb.

    In Excel I'd use something like

    =EOMONTH(TODAY(),-1)
    

    to get the end of the previous month.

About

Avatar for Chalfie @Chalfie started