Categorization of Ticket based on created and planned date

Balasubrahmanya
Giga Contributor

Hi,

I have a requirement to categorise tickets to planned tickets and unplanned tickets. The best way i found is to compare week number of created date and planned start date. If created date week number and planned start date week number is same, then I call as a unplanned ticket if not planned ticket.(Planned start date week number should be at least created date week number +1). Looking for support on the same. Kindly help! Thanks

 

Balasubrahmanya P

0 REPLIES 0