Search results for query: *

Hi, I am struggling with how to do the following calculation. I cant get a clear answer on if nested calculations on numbers only on colors. Column1 Column2 Column3 [End Date] Years Purge Date 1/31/2015 7 12/30/2021 1/31/2015...

I am working with SharePoint 2013, with Nintex and KnowledgeLake add ons and I am new to ALL three. I have a basic Document Library for records retention. One of my columns is "Purge Date" I want to create a workflow that pulls all the documents with a purge date greater than current date and...

Hi, I am using Crystal 2011 sql command to pull data from a progress environment. see command below. Problem is the highlighted line is only returning the second convert function. Can someone please tell me what I am doing wrong?ponder. I would really appreciate help. SELECT...

Hi, I am using Crystal 2011 sql command to pull data from a progress environment. see command below. Problem is the highlighted line is only returning the second convert function. Can someone please tell me what I am doing wrong?[ponder]. I would really appreciate help. SELECT...

Hi, I have the following union query that I am using to access data from a Progress Open Edge using Crystal Reports 2011 and I am getting the error: No of expressions projected on either side of set-op dont match (7582). Both queries work fine independently and I can't see what is wrong with...

Hi all, can anyone tell me what I am missing here. Using CR2011 and needed to create the following command. Tested piece by piece and command works until I get to the final "TaskNote"."NoteText" I get the error "the text, ntext and image data types cannot be compared or sorted, except when...

Hi,I'm need to exclude specific data from a very basic crystal 2011 report. I have identified the data that I need to exclude and I can surpress the data, I need to also only get the actual total count. Goal is to only select the Orders with only 1 TaskNoteID and exclude that OrderID all...