445 canlendar

[Guest]

In shipping company, they sometimes using 445 calendars, which means
regrouping the dates into 4 weeks in the month of Jan(from 2 Jana to 29
jan), 4 weeks in the month of Feb( from 30 Jan to 26 Feb), then 5 weeks in
the month of March(27 Feb to 2 April). Then loop again starting from 3 April
using 445 method.
So Jan, Feb, Apr,May,July,August,Oct and Nov are having 4 weeks. The rest of
the months are having 5 weeks.

I have a field called DATE in my table, the format is mmm/yyyy. Is there a
way that i can change the default time setting or through some coding, so
that when i input a certain date, say 30 Jan 2005, instead of showing
Jan/2005, it will show Feb/2005?

Thanks very much for your help.

 

[Guest]

Create a lookup table that contains a startdate, enddate, and what you want
to store in the table. Then if you enter a date, between the start/end date,
you can compare it against the table and store the value you want.

HTH

Sharkbyte