Hi all,
Hoping someone can help with a solution! My company has numerous assets that are โactiveโ for long periods of time. I have a formula to calculate the โActive Statusโ based on the Asset Launch Date & Asset End Date (see below for reference).
I would like to make an additional field that lists ALL dates an asset is going to be active based on the start and end dates (placeholder included in the image above). For example, if Asset Launch Date = 9/1/22 & Asset End Date = 9/5/22, Iโd like the ALL ACTIVE DATES field to read: โ9/1/22, 9/2/22, 9/3/22, 9/4/22, 9/5/22โ
Note: This field would be hidden 99.9% of the time and ONLY used in an Interface Filter element to allow users to type in specific dates (i.e. 9/3/22) and see the assets that will be โActiveโ on that date.
If there is another solution you can think of, feel free to leave it here as well!
Thank you in advance!