Counting the number of days in a month

[Alvin85]

I have a textbox by the name txt_date. The user will key in the date. The program is supposed to count the total number of days in the month which the user had key in. May i know what is the coding to do the counting?

Example 1: user keyed in 5/2/2020. The program supposed to display day in 5/2/2020 is 29
Example 2: user keyed in 5/2/2018. The program supposed to display day in 5/2/2018 is 28.

 

[moke123]

You can get the 0 day of the next month which is the last day of the previous month, if that makes sense.

Function DayCount(dte As Date) As Integer

DayCount = CInt(Day(DateSerial(Year(dte), Month(dte) + 1, 0)))

End Function

this should always give you the last day of the month even if it is a leap year.

 

[moke123]

Except for February, each month has a consistent number of days so I don't understand the question. Can you try again.

I think February or Leap Year is his issue. His sample data is confusing as its formatted day/month/year

 

[Gasman]

I think February or Leap Year is his issue. His sample data is confusing as its formatted day/month/year

That is how we enter dates in the UK, so not confusing to us.
In fact Access catches a lot of UK newbies out having the m/d/y format. :banghead:

 

[Uncle Gizmo]

I always thought the way of finding the last day of a month was very clever. All you do is find the first day of the next month and take one off!

Sent from my SM-G925F using Tapatalk

 

[moke123]

That is how we enter dates in the UK, so not confusing to us.
In fact Access catches a lot of UK newbies out having the m/d/y format. :banghead:

It always confuses me especially when the posters location is unknown.
Luckily us Yanks don't have to worry about access confusing our date formats

 

[Uncle Gizmo]

Luckily us Yanks don't have to worry about access confusing our date formats

I could never really understand why Microsoft, who provide international software, didn't use the international date format as standard... I do understand as an American company that they would have a tendency to go with their own countries date format, however underlying their software is a programming language, VBA, and the international date is just perfect for programming in that it sorts ascending/descending properly. So from the programming point of view it makes a lot of sense to use the international format...

 

[Gasman]

What is confusing to a newbie is if you place a date parameter in a query which then asks for the date, one can enter 14/07/2018 (dd/mm/yyy format) and Access will convert it. However if you write code you need it in mm/dd/yyyy format.

That is what I feel catches people out, until one learns the difference.

 

[NauticalGent]

Luckily for us yanks, MS is an American company so the date format is in our favor. Just about everywhere else in the world uses the dd/mm/yy format. Gets confusing sometimes.
In the military, to avoid this, we were taught to use DD-MMM-YY.

Also, here in Italy, regarding currency they use a period as the thousands separator and a comma as the decimal point. For example $25,000.67 would be represented as €25.000,67.
Not as confusing as the date format but still curious as to why the cultures are so diverse.

 

[Gasman]

In France they have AZERTY keyboards, not QWERTY keyboards.

That takes a bit of getting used to, and again when you get back to your qwerty keyboard.

Luckily for us yanks, MS is an American company so the date format is in our favor. Just about everywhere else in the world uses the dd/mm/yy format. Gets confusing sometimes.
In the military, to avoid this, we were taught to use DD-MMM-YY.

Also, here in Italy, regarding currency they use a period as the thousands separator and a comma as the decimal point. For example $25,000.67 would be represented as €25.000,67.
Not as confusing as the date format but still curious as to why the cultures are so diverse.

 

[The_Doc_Man]

Perhaps they settled on mm/dd/yyyy since doing so would only annoy half the world whereas using yyyy/mm/dd would annoy everyone

Pat, I've NEVER known Microsoft to avoid annoying everyone. They do it with such ease, mostly I guess because of how much practice they have had in doing so. Which is why I am surprised they didn't pick yyyy/mm/dd format.