What NOW() function will output??

[#1]

stalwar1‌s@@@@@who knows what the now function used below in my expression will produce??

IF(TICKET_STATUS = 'WORK IN PROGRESS' OR TICKET_STATUS='HOLD' OR TICKET_STATUS='ASSIGNED' OR TICKET_STATUS='NEW',

IF(TIER='GOLD' AND NOW()>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA'),

IF(TIER='SILVER',

IF(DECODE_PRIORITY ='High' AND (NOW()+2)>RESOLVE_BEFORE,'OUT_OF_SLA',

IF(DECODE_PRIORITY='Medium' AND (NOW()+7)>RESOLVE_BEFORE,'OUT_OF_SLA',

IF(DECODE_PRIORITY='Low' AND (NOW()+10)>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA')))))

I want the number(2) in  (NOW()+2) to be in DAYs and not HOURS??

e.g NOW()+2DAYS

[#2]

Thanks. I will do that.

[sunny_talwar]

Super

[#4]

Hi Sunny,

  Hope u having a good day, I know you advised me to refrain from having different topics in a thread, but in this case I feel I would not be able to explain myself to those not familiar with my app as you are.

  Attached is my App. when I click on any option of the filter pan "REMEDY_SLA" and "TIER_INCIDENT_SLA"  pane together, it inflates the figures on their respective Line Graph, but the correct figures are when they are not clicked at the same time. Can you help me check and see where I am doing something wrong?? Thanks

[sunny_talwar]

Will check once I reach work

[#6]

Thanks !!!

[sunny_talwar]

Which tab and what object am I looking at?

[#8]

"REMEDY_SLA" and "TIER_INCIDENT_SLA" tabs and their respective line chart graphs. Thanks 

[sunny_talwar]

I am neither seeing REMEDY_SLA or TIER_INCIDENT_SLA tabs?

[#10]

oh Sorry. its on the SDS DASHBOARD(page 1) sheet.

[sunny_talwar]

See if attached is what you wanted