Regarding date

[klee]

HI,
I came across a problem about date in my form. I have a beginning date and an ending date. Logically, the beginnig date should go before the ending date, but now, I can type in any date I one, for example, my beginning date can be 11/11/2002 and ending date: 12/11/2001.

Besides, is there anyway that the form can generate the date by itself, which means whenver you click on the form, there is a date appear.

Thank you very much

 

[mrssevans]

If you want someone to type the date in you can set the Validation Rule so that the ending date field must be greater than the starting date field.

As far as the form setting the date you might try putting the date in the default work with that. Hope that helps!

 

[klee]

Thanks mrssevans,
So do I just type the ending date must be greater than beginning date in the Validation Rule Column?

 

[klee]

I have tried to use the validation rule, but it does not work at al. I have a requestDate, and a DateNEeded. I did not changed anything in my requestdate, but in my validation rule for the DateNeeded, I typed in "DateNeeded">"requestDate". It does not work. Is there any recommendation

Thank you

 

[jwindon]

>=[DateRequested]

On your form, in the Validation rule for the control [DateNeeded]

Use the brackets.

 

[klee]

thanks jwindon,
I'm sorry about that, I thought it is related to VB, so I went to that area. Thanks anyway I will try that out.

 

[jwindon]

Can be done in different ways, however you have indicated that you are (currently) VB lacking, so I gave you the straight out answer.

Again, post back on the same thread if you want something a little more.

Good luck.

 

[sjkewley]

if you want the date to automatically appear, set the default value as =now()