+1Hello,
I use lucidScale to monitor my AWS cloud. I have created a specific template for EC2 instances with different informations and i want to add a conditional formating to alert me when an instance is up since more than 1y.
I tried to use a condition with “LaunchTime“ but a i could only refer to a static date like “start with 2022..”. Could you give me if a formula to warn me if there s more than 365d uptime ?
thx
Best answer by geoffmaddox
To implement this, you can use the DATEDIFF formula function (https://developer.lucid.co/formulas/#datediff) which allows you to determine the time between two dates. In this case, you would want to also use the NOW formula function (https://developer.lucid.co/formulas/#now) to get the current date. Note that this returns an integer, so it wouldn’t give you much granularity.
datediff("years", @"LaunchTime", now) >= 1
Another option would be to use the YEARSAGO formula function (https://developer.lucid.co/formulas/#yearsago), which returns a fraction of the number of years from the current date. This would let you differentiate between exactly 1 year ago, and more than 1 year ago.
yearsago(@"LaunchTime") > 1
To implement this, you can use the DATEDIFF formula function (https://developer.lucid.co/formulas/#datediff) which allows you to determine the time between two dates. In this case, you would want to also use the NOW formula function (https://developer.lucid.co/formulas/#now) to get the current date. Note that this returns an integer, so it wouldn’t give you much granularity.
datediff("years", @"LaunchTime", now) >= 1
Another option would be to use the YEARSAGO formula function (https://developer.lucid.co/formulas/#yearsago), which returns a fraction of the number of years from the current date. This would let you differentiate between exactly 1 year ago, and more than 1 year ago.
yearsago(@"LaunchTime") > 1
+1thx it works exactly how i need !
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
