use Deluge to limit records
I'm creating a view for a team member who only needs to see the most recent jobs we are working on.
I'd like to set a criteria that will limit her view to records that have Estimated Start Dates from today to three months from today.
I found a similar question at http://help.zoho.com/portal/en/community/topic/zoho-currentdate-in-url?
but there the question-asker wants to use this in a URL
I know there is a Zoho-wide variable called zoho.currentdate
So in psudo code it is:
Estimated_Job_Start_Date is between zoho.currentdate and zoho.currentdate+90days
However the format of his turning zoho.currentdate into something you can add 90 days to doesn't seem to work in "Set Critera"
Is there an easier way to do this?
I pasted his code:
//dd
dd = (zoho.currentdate.getDay()).toString();
//yyyy
yyyy = (zoho.currentdate.getYear()).toString();
//mmm
mm = zoho.currentdate.getMonth();
MonthsOfYear = List:String({"Zero", "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"});
mmm = MonthsOfYear.get(mm);
TodayString = dd + "-" + mmm + "-" + yyyy;
and got this error
Field dd does not exist in the form PM