Hello,
I would like to display some text or an image using an if-then statement... depending on the difference between today's date, and a future date in my database.
So what I would like is if the date in my database is within 31 days of today, show the text/image. The text/image should show for a total of 31 days as today's date gets closer to the date stored in the database. When todays date passes the date in the database, it should hide the text/image.
i.e. The date in the database = 2002-08-27
Today's Date = 2002-07-16 - Hide Image
Today's Date = 2002-07-29 - Show Image
Today's Date = 2002-08-18 - Show Image
Today's Date = 2002-08-28 - Hide Image
Can someone show me an if-then statement that can achieve this?
Thank you!!
Peter