We use the "from today" function quite often, whether it be in BAQ's or Excel.
We're trying to replicate this function in Portal but having no success. I tried using the "GetDate" function with the OrigDate on CRMCallLog, so it looked like [Orig Date]>=(GetDate()-365), but that didn't work. I also tried CurDate, but that's a Progress function not SQL so that didn't work either.
Any suggestions for emulating the fromtoday function in Portal?
Ken
[Non-text portions of this message have been removed]
We're trying to replicate this function in Portal but having no success. I tried using the "GetDate" function with the OrigDate on CRMCallLog, so it looked like [Orig Date]>=(GetDate()-365), but that didn't work. I also tried CurDate, but that's a Progress function not SQL so that didn't work either.
Any suggestions for emulating the fromtoday function in Portal?
Ken
[Non-text portions of this message have been removed]