month February

[azhar2006]

How to make the month of February 30 days, instead of 28 days?

[June7]

Why? Where would this be useful? February has 28 or 29 days, never 30 or 31. Other months are either 30 or 31. Do you want the 31 day months to be 30 days?

[azhar2006]

Thanks very much June7


What I want is that every months the year is 30 days.
I to in order to calculate wage salaries, and I want to make every month of the year it is 30 days.

[June7]

I think most payroll processes use the number of workdays/hours in year to calculate hourly wage.

[azhar2006]

Thank you June7
But this is the organization I work request.
I used something like this. But based on the history of the computer and I do not want it.

Expr1: Switch(Month(Date())=1,30,Month(Date())=2,30,Month(Date())=3,30,Month(Date())=4,30,Month(Date())=5,30,Month(Date())=6,30,Month(Date())=7,30,Month(Date())=8,30,Month(Date())=9,30,Month(Date())=10,30,Month(Date())=11,30,Month(Date())=12,30)

[June7]

Since every month is 30 don't need the expression, just use the number 30 in your calcs. If you want a field in query to show the number 30, simply:

Expr1: 30

[ranman256]

you cant. it can never be done.
you can put it in a string, but not a date field.

[ItsMe]

If you have a field in a table named, "SomeDate", you could create an alias in a Query. Include your table in a new Query. The following syntax (used in a new field as an alias) would cause each month to be followed by "30". Understand that this is not a number or a date; it is text. So, the result does not serve a purpose other than being an illustration.

MyMonth: Month([SomeDate]) & ", 30"