Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(len([Date Closed])<=0,now(),[Date Closed]) as DT2
Instead of Now() i want to find last working days of [date closed] month.
the date format is- 'mm/dd/yy hh:mi am/pm'
Ok, thank you for uploading the excel.
I think we are talking about these records
Ticket Type | Ticket No | Date Raised | Assigned to group | Service name | Closed by | Date Resolved | Severity | Status | Depicts |
A | 187576-T | 03.09.2015 13:35 | System Portal | S KC | 1 | Open | Deployment | ||
A | 187548-T | 03.09.2015 08:47 | System Portal | S KC | 1 | Open | Deployment | ||
A | 187509-T | 02.09.2015 13:37 | System Portal | S KC | 1 | Open | Deployment | ||
A | 187465-T | 01.09.2015 16:13 | Clearcase | S KC | 2 | Open | Deployment | ||
A | 187435-T | 01.09.2015 10:14 | Clearcase | S KC | 2 | Open | Deployment | ||
A | 187380-T | 27.08.2015 16:17 | System Portal | S KC | 2 | Open | Deployment | ||
A | 187232-T | 25.08.2015 12:34 | System Portal | S KC | 2 | Open | Deployment |
Could you please tell us which date you want to see in [Date Resolved] for each record if not Now() / Today() or End of Today's Month / Last working date of today's month?
yes you are right.
Here all the ticket resolved in sep except open one.
so i need to consider end working day of date resolved