Displaying minimum date

[gsrajan]

I need your help please.

I have six textboxes in my form. First 5 textboxes have dates ( MMDDYYYYY). In the sixth textbox I need to display the minimum date among these five dates.

Thanks for your help.

 

[pbaldy]

Presuming those are actual dates:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857

Sorting won't work correctly if they're text fields.

 

[gsrajan]

Yes, they are actual dates like 02/04/2014, 04/08/2014. I am not able to figure out how to do from the link you provided.

Thanks.

 

[pbaldy]

On a form you could use the function in a textbox:

=Minimum(Field1, Field2,...)

 

[gsrajan]

Thank you very much. It is very helpful.

Thanks again.

 

[pbaldy]

No problem.

 

[gsrajan]

I am back again.

I am getting an error message "FieldArray(0)=<Subscript out of Range>" error message. currentVal = FieldArray(0) is highlighted in the debug mode. I double checked the names of the text boxes, they are correct.

 

[pbaldy]

Can you post the db here?

 

[gsrajan]

Thank you,

It is a splitted DB. You need only the forms or both?

Thanks.

 

[gsrajan]

Thank you, I was able to resolve it. When I compiled, the error message is gone.

Thanks for your help.

 

[pbaldy]

Ah good, I've been tied up with a payroll problem. Glad you got it sorted out.