Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4808 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hello

I'm going nut over dates again.

I need to do a "simple" monthly maintenance schedule.

First table is the hardware with description, picture etc.

Second table Line_Items shows as a portal in the hardware table

this is where the maintenance is selected. It has 5 visible fields

Maintenance description - Starting month - Ending month - Frequency - Next maintenance

(Frequency choices = weekly, bimonthly, monthly, trimester ... yearly)

I need to figure the month of the next schedule maintenance to build a monthly report.

The report find criteria is the Next Maintenance field.

Exemple: we're in november:

--description ------start month ---End Month---frequency-- Next Maintenance

Clean something - march - december - monthly = 11

Change something - december) - april - bimonthly = 12

oil something - October -may - semesters = 1

Since I'm dealing only with months, do I have to use complete dates?

I'm not sure how to convert month 14 into month 2 if I don't use date.

Dates gives me a headache

Any help or link to solution would be appreciated.

Thank you

Posted

I need to figure the month of the next schedule maintenance to build a monthly report.

I am not sure I understand the task you describe. Could you explain, step-by-step, how you arrived at the answers in your examples?

I'm not sure how to convert month 14 into month 2 if I don't use date.

Mod ( month - 1 ; 12 ) + 1

This topic is 4808 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.