Hey everyone,
I need some help as I was able to get this date using Google Spreadsheets but I would love to create a report on Explore.
I want to create a report where I can see how many tickets were created within 30 days of the warranty start date. (Our field ID is 25353746 and it's a date type field)
This would mean creating an IF statement like:
IF "Ticket Created date" < "Warranty Start date " + 30 days THEN TRUE
ELSE FALSE
I'm not sure what is the best practice to do this? Can someone help me?
Warranty Start Date vs Ticket Created (Calculated Attribute)
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.