Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to get Days in Queue as another column in straight/table box by using below formula
=DAYS360(TODAY(),Date)
I sit possible to get this in script?
CompanyItems:
LOAD ID,
Name,
ContactMethod,
Portfolio,
WorkItemType,
Priority,
Date;
SQL SELECT *
FROM CompanyItems
where Date between #01/07/2013# and #25/10/2013#;
Check additional options in your expression:
I gave in Text color as =If('Your_Date'<Today(),RED(255),RED(128)) because i need RED colour.
And moreover I need to appear RED colour only the Days in Queue Number is less than TODAY
Is that possible. please let me know.