Date Entry Validation

[JetLi]

How do i set in field rules the date validation so that the new date is not later than the last date of the last record.
for example the last diagnosis date of a patient is 1/2/2012,then the user cannot enter 1/1/2012 or 12/31/2011 or 12/30/2011 and so on...
Sample Scenario
Patient No Diag Date
01 1/2/2012
01 User cannot input 12/31/2011 here , it must be 1/3/2012 or future

Another sample would be, on a savings app.the user should not input
the new transaction date to be later than the last transaction date.Thanks

[Stan Mathews]

Re: Date Entry Validation

Why have them enter the date?

Set the default expression to date() and set the Skip to .T. in the field rules.

In the second case you define Validations in the field rules, Custom section.

[Tom Cone Jr]

Re: Date Entry Validation

I think the solution to this will be finding a good way to identify the "last" record prior to the current one. There are several possibilities.

Once the correct "last" record is found you could run a script in the CanSaveRecord event in field rules for the table to validate the diagnosis date in the pending record.

Perhaps someone else will post a simpler suggestion.

[JetLi]

Re: Date Entry Validation

I think the solution to this will be finding a good way to identify the "last" record prior to the current one. There are several possibilities.

Once the correct "last" record is found you could run a script in the CanSaveRecord event in field rules for the table to validate the diagnosis date in the pending record.

Perhaps someone else will post a simpler suggestion.

If this can't be done in a point and click in alpha field rules, then this would be a good suggestion, question is HOW? don't know yet Xbasic.Thanks!

[JetLi]

Re: Date Entry Validation

Why have them enter the date?

Set the default expression to date() and set the Skip to .T. in the field rules.

In the second case you define Validations in the field rules, Custom section.

Please show how? Thanks!

[Stan Mathews]

Re: Date Entry Validation

No. You can easily find this in the wiki.

[whanigsberg]

Re: Date Entry Validation

Jetson,

You also have to define what you mean by "last record" precisely.

I presume you mean last record for the particular patient. To figure out how to do this--not the syntax, but the object of the syntax--we would need to know if each clinical intervention with a patient is a separate record or if all interventions for a given patient are stored in a single record (which will give you problems in the long run).

Perhaps you could post a sample database with nomnative data removed.

Bill

[JetLi]

Re: Date Entry Validation

I think the solution to this will be finding a good way to identify the "last" record prior to the current one. There are several possibilities.

Once the correct "last" record is found you could run a script in the CanSaveRecord event in field rules for the table to validate the diagnosis date in the pending record.

Perhaps someone else will post a simpler suggestion.

Tom,I think your suggestion is the best way to do it,Dont know how this can be done in Alpha,but I can do it in vb6, before saving the record, i would code a routine to check for the last diagnosis date based on a patient number being currently edited,then after getting that value, i can then compare it to the new date of diagnosis entered by the user,then check if the new date is less than the last diagnosis date, my purpose in doing this is to eliminate the possibility that the user will make an error in setting the diagnosis date,of course in alpha, it is very easy to set the default date so that users will not make a mistake, but sometimes users will encode the diagnosis date at a later time and i don't want users to make a wrong entry on diagnosis date. Tom's idea is the same with me but i don't know how it is done in alpha five.How?

[DaveM]

Re: Date Entry Validation

Tom actually told you how. He did not write your code for you. Again, this can be found in the wicki as Stan said. Bill gave you a real good suggestion also.

You do it basically the same as vb6. Once you learn what an onsave event is, the rest will be easy.

By the way, these three are some of, if not the best on this forum.

[JetLi]

Re: Date Entry Validation

Thank you!