I want to check for the last date something occurred for a specified client. I have a procedure that checks for the last occurrence. The problem occurs when there is no record at all. How do I test for that? It returns {}, which is not null and doesn't register as empty with mmType.IsEmpty(). What's the best way to handle this? If I cast the return value as a string, SQL will give me a spelled out date. Do I need to get a count first and only check for the date if the count is > 0?
Any suggestions are greatly appreciated.
If anyone's interested, I did finally figure this out. I had to cast the return value as a string and then use mmType.IsEmpty() to test for an empty string. If not empty, then I use DateTime.TryParse to return it to a datetime type.
Linda Harmes
HiBit Technologies, Inc.