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