Hi all. I currently have a custom list for an employee award. This is an award that is given every 3 months. My list handles the nominations. I know which quarter (3 month period) my item is in as I have a calculated column (=ROUNDDOWN(((INT(MONTH([Date Of Nomination]))-1)/3),0)+1). What I am trying to do is create a view that displays items where my calculated value = the quarter of the current date. In mathematical terms WHEN ROUNDDOWN(((INT(MONTH([Date Of Nomination]))-1)/3),0)+1 = ROUNDDOWN(((INT(MONTH([Today]))-1)/3),0)+1. I cannot seem to do this anyway. I have tried saying in the view in the Filter section, but it just doesn't return any results. I also tried to make a column based on today, but this doesn't work either. Any ideas... Andrew Berry - Software analyst/Developer

Hi, It’s useless to call the “Today” in a calculated column. That’s because this kind of column is not actual dynamic column based today. Additionally you are aware the list view filter disallow you use the function like “MONTH” with “Today”. So this approach will not work for you. Here is a workaround you can consider as following: You need create two calculated column: The first day of the season The last day of the season After you have created these two columns, you can uses them in list view filter like The first day of the season<=[Today] The last day of the season>=[Today] Hope this helps Thanks! Stanfford

Thanks.Andrew Berry - Software analyst/Developer