Report for Contracts module
Hey Guys,
I have been fighting the query tool. I am attempting to extract a report that contains contracts by name that are about to expire, I was going to use a 60-90 day lead time to catch them before they expire.
It seems the date info is stored as an integer that looks like came from LONGDATE. I cant seem to convert it back?? I keep getting data truncation errors.
Any help is greatly appreciated.
Thanks
I have been fighting the query tool. I am attempting to extract a report that contains contracts by name that are about to expire, I was going to use a 60-90 day lead time to catch them before they expire.
It seems the date info is stored as an integer that looks like came from LONGDATE. I cant seem to convert it back?? I keep getting data truncation errors.
Any help is greatly appreciated.
Thanks