I have a table that stores an expiry date for a certification. (field name = expiry_date)
I want to automatically assign a color to the background of the expiry_date field and a category based on the date:
a date that is over 90 days in the future shows green and selects the category "current"
a date within the next 90 calendar days shows yellow and selects the category "expiring"
a date prior to today shows red and selects the category "expiring"
an empty date field shows orange and selects the category "unknown"
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…