Thanks, rhankey for the response. we pull the store and its opening date into a custom table from external source. Also, users can override this opening date manually. How can this date be setup in member text property.
Probably easier in a custom table for user maintenance particularly if security is an issue. Think ahead and see if there's any other store information you should bring in to the same table too.
Make sure you use global cache as rhankey hinted at. Retrieve all data on the first lookup and store it in memory; you can store it in a dictionary object for quick/easy lookup. There are a number of examples of utilising the global cache in these forums.
