Method Community

if you want to get fancy, and dance around the date conversion a little..... (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  END)  + CONVERT(varchar(10), DateAdd(HOUR,-5,viewActivity.DueDateStart), 20) + ...

In that case you want: (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  END) + viewActivity.DueDateStart + '</b></font>' 

Paul, If I move the END to the end of the statement, the case will not display the requested field unless it results in the ELSE portion of the CASE I did try your suggestion but ended up with the same error. I'll keep playing

Try: (CASE WHEN [DueDateStart] < GETUTCDATE() THEN '<font color="red"><b>' ELSE '<font color="black"><b>'  + viewActivity.DueDateStart + '</b></font>' END)  - I haven't tried this, just a first glance attempt. - better to use GETUTCDATE() ...

So I have another one that I could use some help on.  I want to be able to compare the current time to the requested start date and then color it red if its late.  Here was my idea, but it returns "error generating grid" CASE WHEN [DueDateStart] < GETDATE() THEN '<font color="red"><b>' ELSE ...

In case anybody is interested,  I figured out my own solution: CASE WHEN [ActivityPriority] = '1-Emergency' THEN '<font color="red"><b>' WHEN [ActivityPriority] = '2-24 Hour Response' THEN '<font color="blue"><b>' ELSE '<font ...

I'm trying to create a new dispatcher's dashboard and wanted to color code the Work Order grid based on the priority of the activity.  I figured I could do something along the lines of: CASE WHEN [viewActivity.ActivityPriority]='1-Emergency' then '<font color="red">' ...

  Greetings Methoders!   The new version of our QuickBooks Desktop Sync Engine is now out of beta, and we wanted to give you the rundown about why an update was needed, what this means, and how to make sure you have an updated sync engine.   Why a new sync engine? QuickBooks Desktop requires us to renew/update our ...

Hi Lance, This is a feature we've wanted to implement for some time, but because of the nature of the Quickbooks SDK it's just not possible for us to accomodate multi-lingual data. Lots of developers have tried to build it out, but unfortunately it's not possible. Sorry that's all I have. Naeem

No problem.   I have not found any patern to the problem.  At first I thought it might be when a line was added to an invoice in Quickbooks, but I have since found that seems to work okay.   It is possible the line was added while the sync was not on, but I would think that is suppose to update when the sync comes on ...