Marco Cruz Posted November 12, 2020 Share Posted November 12, 2020 What is the expression for selecting the year of a particular date column I tried this function but it does not work, [ColumnDate1]=Year('2019') Link to comment Share on other sites More sharing options...
Gaia Paolini Posted November 18, 2020 Share Posted November 18, 2020 You would extract the year from a date or datetime column. So something like Year([ColumnDate1]) returns a column that contains an integer, the Year of the date in [ColumnDate1] 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