0

ms access[tblmonthly - month, total]

month = lbldate [actually my date format is lbldate.Text = Date.Now.ToString("MMMMMMMMMM dd, yyyy") , im using this format for my daily sales and i can save and update at the same time, but in Monthly sales i want to use the same format but i want to save in field 'month' is only the month[MMMMMMMMMM] ,is it possible ? or should i use other format?

this is what i want in database[example]
January | 1000.00
February| 1900.00

2
Contributors
2
Replies
9
Views
2 Years
Discussion Span
Last Post by jez9
0

To get month name you can use MonthName(Date.Now.Month) function, which can convert integer values 1 to 12 to their corresponding month name.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.