12-03-2009 07:54 AM
In previous versions I was able to build a condition where a date field Does contain data. But now that we upgraded to SP2 when I go into query builder and want to insert a condition where a date does contain data I get a popup error saying "invalid date format". Why was this changed? Isn't this a bug? Is there another way to accomplish this? In this case I want to have a group where the customer's contract expiration has not been input - a null date field (does not contain data).
Thanks.
Ted
12-03-2009 10:09 AM
I suggest trying using the "literal" format approach - not sure if it will work but a suggestion.
Also, take a look at the group SQL on the "older version" for this as a guide.
12-04-2009 07:04 AM
How do you use the literal to find out if there is a date value? My problem is that I need to identify that there is a value input here and more to the point why is this broken now? It appears to have changed in 7.5 because I had the same problem with 7.5.1. To me this is a bug because we should be able to build groups like this.
Ted
12-04-2009 08:52 AM - edited 12-04-2009 11:44 AM
Works in the web......
Works fine in 7.2.2 LAN
I've reported it as a bug.
Update: It's a KI - Defect# 1-67882 Scheduled for 7.5.3
12-06-2009 05:39 PM
Thanks RJ, I appreciate your follow-through on this. For those who know me I have been an avid supporter and advocate for SalesLogix for a number of years. Originally starting out in the Business Partner community and now working on "the other side of the fence" so forgive me for going into a small rant:
/start rant
What the heck is going on up at Sage!!!!??? How can a bug that has been known since the beginning of the 7.5 lifecycle go on this long? Yes, the web is the all mighty Mecca, the holy grail and all that other worthless fools gold that all those who drink the Kool Aid start to believe in, but don't forget to support your base product that has given you all jobs for so long and is still used in the industry. Can't someone get off their but and just fix this? It is "slotted" to be fixed in 7.5.3 but I have no doubt it was slotted to be fixed in 7.5.1 and 7.5.2 and you guys just let it slip. Come on, get up and fix these LAN issues rather than putting all your eggs in this web client.
/end rant
Ted
12-06-2009 09:49 PM
12-06-2009 09:52 PM
12-07-2009 05:08 AM
12-08-2009 06:16 AM
12-08-2009 06:17 AM