You need to sign in to do that
Don't have an account?
SATZ
Filter condition for date field
Hi all,
I am using class object as lookupfield in Enrollment object.Both are custom object.
For class i want to add a filter condition the Class start date and time is equal to today .
here i want to specify today date and timecompare date and time or date
But It shows error .
Hello,
That error occur because Today is not a write value of the date/time field you have to mention particular date and time to compare.
Thanks
Ankit
Is Start Date/Time a DateTime datafield? It looks like so..
To my knowledge SFDC doesn't support date functions in lookup filters. So you have to create a formula field of type date/datetime depending on data type of Start Date/Time field and use values - Today() or Now().
Then use this field in the criteria
Class: Start Date/Time equals Field The_Formula_Field__c
Does this help? Let me know.
I think formula field may not help, as they are filled after the record is saved.
Looks like there is no straight forward solution for this :(
May have to use VF pages with some javascripts.
Hi Satz
There are lot of limitations on lookup filters in salesforce where we cant use the date fileds,month etc :