We would need a joblog to assist with the SQL Server question. You can email that to [email protected].
As far as the timestamp question is concerned, if you perform the DATE function on the timestamp field, you will end up pulling the date out of the timestamp. You may need to do further formatting once that is done if the date is not in the format you need. DATE(field) --- field is your timestamp field.
Feel free to respond to this forum or contact us at [email protected]
Originally Posted By jdaugherty