Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding the payperiod that included 12th of month
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01137078
Message ID:
01137089
Vues:
19
>This kind of logic should work.
>
>IF BETWEEN(12, DAY(PpBeg), DAY(PpEnd))
> *--Select the rec.
>ENDIF
>
>-Matt

Won't work if the pay period spans across 2 months (last week of month, 1st week of next month). BETWEEN must have the smaller comparison number first.



Update:

No, that wouldn't work, either. Say the dates for the pay period are 6/20 to 7/4. The 12th isn't between those 2 dates.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform