Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the first month day.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00522336
Message ID:
00522338
Views:
8
>Hello at alls.
>I wonder to know with one the way to get the first month day since any date and in format DD/MM/YYYY.
>TIA

DATE() - DAY(GoMonth(DATE(),1)-1)

Should find you the first day of any date you enter. So replace DATE() with a variable storing the date you are interested in and it should find the first day of the month. If you want to know the Character day of the week surrond the above with the function CDOW()

HTH
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Reply
Map
View

Click here to load this message in the networking platform