Is it possible to create a view using the getWeekOfYear() function to display records belonging to that specific week?

Is it possible to create a view using the getWeekOfYear() function to display records belonging to that specific week?

The getWeekOfYear() function can be used to view records whose date field belongs to the current week. To do this,

1. Create a Formula field in your form with the following expression as given below, where Date_1 is the name of the date field in your form. You can also use the Added_Time field instead of your Date field, based on your requirement. The formula expression will return the week number in the Formula field.  

Date_1.getWeekOfYear()

2. Specify the Advanced View criteria as given below, where Formula_1 is the name of the formula field added above.This will list all the records belonging to the current week. 

Formula_1 == zoho.currentdate.getWeekOfYear()

    • Related Articles

    • Is it possible to create a view to display only those records added by the login user?

      o restrict a user from viewing records entered by other users, a Criteria should be set for the view . When the following criteria is set for the view, only the records added by the user who is currently logged into Zoho Creator, is displayed in the ...

    • Common Operations with records

      Record Navigation Navigation primarily means the process of moving back and forth within the records. In Zoho CRM, navigation allows easy movement between the records; it provides options to choose the number of records to be displayed in one page ...

    • Common Operations with records

      Record Navigation Navigation primarily means the process of moving back and forth within the records. In Zoho CRM, navigation allows easy movement between the records; it provides options to choose the number of records to be displayed in one page ...

    • Custom Function: Create_Job

      This custom function can be used to create a new job in any layout. It can also be configured to carry forward necessary field values from the former job to the latter.   Business Scenario Helen is the head of Procurement Management in her ...

    • Using Roster View for Temp Scheduling

      You can now keep up with temp schedules using Zoho Workerly's Roster View. Overcome the difficult maze of complex temp staffing issues.  Here are some benefits of using Roster View for temp scheduling: Avoid overloading your temp staff Manage empty ...