Member Avatar for jez9

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
  • 279 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by jez9
Member Avatar for Santanu.Das

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.

Member Avatar for jez9

@Shark_1, thank you :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.