Murique Smith Posted April 17, 2019 Share Posted April 17, 2019 I want to filter my data to only show data that have the data from January 2019 to todys date. Can you pleace tell me if this is the correct expression DateDiff("yy",[Date],DateTimeNow())>=0 Link to comment Share on other sites More sharing options...
Richard Pobi Posted April 17, 2019 Share Posted April 17, 2019 Properties > Data > Limit data using expression > Edit. Then write the below expression. That will work. The "Date Column" is the column you are using from you table. Then format the date you want to start fetching date from by using Date datatype. [Date Column]>=Date(2019,01,01) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now