Search results for query: *

Update This formula works perfectly =IF(Years=”7”,[End Date]+2555 This one does not work =IF(Years=”7”,[End Date]+2555,IF(Years=”10",[End Date]+3650,IF(Year=”5",[End Date]+1825.""))))

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...

fredericofonseca Hi, I tried to suggestion..... thank you very much by the way. When I tried the code I got an Syntax error in SQL statement at or about "varbinary(100)

Hi Andy, The two expressions in this issue do return data individually. They are "WorkMobile" and "OptOutMobile" listed above in the statement. I attached a sample of what is returning and the desired outcome...

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 Dell, Thank you for your response. Combining the fields in crystal will not be useful with particular report. The access query I have to connect to could potentially have both workmobile and optoutmobile data. The field that I am trying to create is the field that I want to use for my link...

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...

Ok, I have checked the queries, and added columns where there needed to be a filler, still not working, any thoughts? SELECT "ap_invoice1"."kco", "ap_invoice1"."gan_code", "ap_invoice1"."ain_posted", "ap_invoice1"."avm_num", "ap_invoice1"."ain_amount", "ap_invoice1"."ain_retain"...

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 Gordon, thanks for the suggestion. Still not getting!the WHERE clause for TaskId = 2. This is making me crazy i tell ya!

Yea I tried subquery as well. The goal is to get every workorder that only has 1 note record. (dont ask why this was requested b/c idk :-)) Anyway this is the subquery command that i tried and it's still not returning the correct data. SELECT "TaskNote"."WOID", "TaskNote"."TaskNoteTypeId" AS...

Hey Kray4660, SQL, but I found a workaround for that part. SELECT "TaskNote"."WOID",Count( "TaskNote"."TaskNoteId") AS 'CountNotes', "TaskNote"."TaskNoteTypeId" AS 'TypeId',"TaskNote"."TaskNoteCategoryId" AS 'CatId',"TaskNote"."CreateDate" AS 'Date',"TaskNote"."CreatedBy" AS 'Tech', CAST...

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...

still not getting the correct results. trying a 3 part variable to see if that helps. Thanks for the info tho, I appreciate it.

Hi, I tried that, the problem is the 1. My desired result is to only get the orders that had only 1 note.

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...