Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Compare dates

Quote Reply
Compare dates
Hi!

In my LinksSQL every link has two special dates, one is begin_showing, the other is end_showing. That means, the link should only be shown on my page, if I'm in the period between the day of begin_showing and the day of end_showing.

But why does for example this not work: <%if begin_showing eq date%>
If it is written on the screen, both variables are exactly the same, but the result of the if-Statement is false, and it runs over the if and not in it.

In order to compare if the actual day is in this period, I would like to do this (in pseudo-code)

if (date >= begin_showing AND date <= end_showing) OR (if not begin_showing AND if not end_showing)

=> Either it is in the selected period or no begin-and ending-dates are given.

How can I do this?? Thanks, Tina
Subject Author Views Date
Thread Compare dates tga 2195 Mar 14, 2005, 5:33 AM
Thread Re: [tga] Compare dates
afinlr 2085 Mar 14, 2005, 6:02 AM
Thread Re: [afinlr] Compare dates
tga 2078 Mar 14, 2005, 6:35 AM
Thread Re: [tga] Compare dates
afinlr 2067 Mar 14, 2005, 6:13 PM
Post Re: [afinlr] Compare dates
tga 2055 Mar 15, 2005, 12:23 AM