I want to allow users to enter a date, either entering directly or using a calendar control.   I want to edit that the date is in the past.  I need to go back several years, so a date dropdown won't work.

Any suggestions?

Thanks,

Mike

Hi Mike,

Dynamic Forms 3.0 has a new date field where you can set the starting and ending years.  Check out Demo 23 and hit 'Display Hidden Questions. The date field there has a start of -20 and an end of 5.  The starting years define how many years you want to go back from today and the ending years define the number of years going forward.  So in your case, you can set the starting year to -10 and the ending year to 0.

Try it on our test site, www.betasprings.com (use host / dnnhost to log) and see it works for you.  Just add your own page under Dynamic Forms.  Thanks!

Candace

What I'm looking for is to edit that it can't be after today's date.  The change sounds like I'm limited to dates only after this year.   Is there anything I can do for this kind of edit?

Mike

Hi,

I'm kinda of working on the same thing...Except I want a question to be visible if it's not passed a  certain date.  So, if I created a hidden field with a default value of today's date with SQL Validation like:

datefield($(datefield)) <= '03/15/2010' AS IsValid

Then I have a question event check the above field, if it returned true then I would have it display another question.

Is this the right way to do it and is the syntax above correct for the SQL Validation?

Thanks in advance for your help.

Jerry

Dave,

Thanks for the tip!!! Works great!!  Now I'm trying to figure out how to see if I can check if a date is in a range.

So I would like to display the question if it was between 3/15/2010 and 4/15/2010  would this be the correct syntax?

select case
when datediff(day,getdate(),'3/15/2010') >= 0 and when datediff(day,getdate(),'4/15/2010') <=0 then 'Positive'
else 'Negative'
end defaultvalue

Thanks again for your help, it's much appreciated.

Jerry

When I use:

select case
when getdate() between '3/15/2010' and '4/15/2010 23:59:59' then 'Positive'
else 'Negative'
end defaultvalue

It works great...but now I was trying to see if I could use a hidden field to replace the StartDate and EndDate like:

select case when getdate() between '$(PARStartDate)' and '$(PAREndDate)' then 'Positive'
else 'Negative' end DefaultValue

I don't get a result..  Can this be done?  Am I using the right syntax?

Thanks
Jerry