function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
EIE50EIE50 

Text values for the date fields in dynamic dashboard filters

Hi,

 

I am dealing with dynamic dashboards and i have to setup filters for date values. I am trying with TODAY, THIS WEEK etc.,. just like how we choose the range with reports. Can anyone please tell me what are the list of text values that i can use in the date fields. (eg, today, this week, this month, last week, last month, etc,.,)

 

I would really appreciate your help. I just couldnt figure out the right dcoument if there is one for the same. 

 

Thanks.

Best Answer chosen by Admin (Salesforce Developers) 
phiberoptikphiberoptik

They are called Date Literals:

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

All Answers

phiberoptikphiberoptik

They are called Date Literals:

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

This was selected as the best answer
EIE50EIE50

Hi,

 

Thank you very much. I was able to save the dashbaord with values like Last Week (not Last_Week),etc,.,. I still have to test this out and i will let you know if there is a problem.

 

Thanks Again!!
EIE50EIE50

Works Great without any problems!!!!!!!!!