08-30-2012 03:25 AM
In the LAN version under a opportunity grouping I have defined a condition so only records were the EstimatedCloseDate is less than :now is defined.
This works great, and all the correct records show.
Unfortunately this is not working on the web version, I get an error - the date entered is not a valid date. Year is not 2 or 4 digits.
I have ensured the use Value as a literal is selected - but the error still occurs.
Is there a way around this?
07-10-2013 11:13 AM
You need to create the group using the web client. When adding the condition, first check 'use value as a literal' which will insert 18991230 into the value box and then replace it with :now.
07-10-2013 11:44 AM
07-10-2013 02:25 PM
If I understand this correctly, when selecting a data\time field in query builder (for web) and adding a literal value, click ok it prompts a message "The date entered is not a valid date. Year is not 2 or 4 digits"
If that is correct, 7.5.4 was coded with out the feature of using literals in date\time fields. This was added in our 8.0 web offering. There is a possibility you can get the same result by using a literal with the 'In' operator, but it will require a SQL statement returning ID's of whatever entity you are using.
07-10-2013 07:32 PM