2 Replies Latest reply on Oct 19, 2018 12:32 PM by Varma Rajakakarlapudi

    How to perform "Filter to latest date value when workbook is opened" on a calculated date field

    Varma Rajakakarlapudi

      Hello everyone, I created a calculated date field as shown below which will display week numbers in 1,2,3,4,5 format for a month.

      DATEPART('week',[Created Dtm]) - DATEPART('week',DATETRUNC('month',[Created Dtm]))+1

       

      When I tried to use this as a filter , I am not be able to find "Filter to latest date value " option. But I want to filter the data to the latest date when the workbook is opened . Is there any workaround?