Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date like MM/YYYY
Message
 
À
14/08/2006 04:05:19
Mk Sharma
Shrishti Solutions
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01145224
Message ID:
01145226
Vues:
20
>i want to add a date like MM/YYYY
>i required this for expiry date of medician.
>
>warm regards,
>mk.

:-)))
Where is DAY portion? If you want just to add month and year in that format try this:
Add a TextBox in you form. Set its InputMask to: ##/####. In Valid/LostFocus Event or there wher you validate Entry Data put:
LOCAL lnMnt, lnYear
lnMnt  = VAL(LEFT(thisform.TextBoxName.Value,2))
lnYear = VAL(RIGHT(thisform.TextBoxName.Value,4))
IF NOT BETWEEN(lnMnt, 1, 12)
   MessageBox([Month number is not correct])
   RETURN .f.
ENDIF
IF lnYear < 1900 && Or any other year you want
   MessageBox([Year number is not correct])
   RETURN .f.
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform