Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the payperiod that included 12th of month
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137078
Message ID:
01137089
Views:
18
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform