Jump to content

Paycheck Generator - Automatizing Problems


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

Recommended Posts

  • Newbies

Hello, this is my first post so don't be surprised if i don't know the format and the usual procedure followed on this forum, but i hope you can help me anyway, thanx in advance :

I'm currently working on a database solution for a small business, creating a complete registry of all their employees, with contract details, and an added function: the app calculates the monthly paycheck for each employee based on the contract type and days worked. The problem I've encountered is relatively simple, but this is my first contact with filemaker so I've had some problems with the scripting involved, I'll explain:

To calculate paychecks the app uses assigned variables for each contract type, and multiplies by the number of days worked during the month, my problem is that whenever the salary to calculate is of the month of december the app returns an erroneous value, as I have to calculate the number of days between Date(CurrentDate(12/1/XXXX) and (CurrentMonth+1/1/XXXX), for some reason the program reads this as month 13(wich obviously doesn't exist) instead of just adding 1 to the currentyear value.

I'm a novice and have been using Filemaker during 1 month aprox, so if any of this didn't make enough sense tell me and I'll try to clarify, thx,

Sam :

PS: an [if] would solve this but I don't know exactly how.

PS2: Dunno if this is even the right forum to post my problem, if it isn't someone point it out plz.

Edited by Guest
Link to comment
Share on other sites

You need a calculation something like this:

If ( Month ( date ) = 12 ;

Date ( 1 ; Day ( date ) ; Year ( date ) + 1 ) ;

Date ( Month ( date ) + 1 ; Day ( date ) ; Year ( date ) )


I attached a simple file that has a date field, a calc field that use the above calc, and a field that tells the days detween the two dates. Hopefuly that will help.


Edited by Guest
Link to comment
Share on other sites

This topic is 5659 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

  • Similar Content

    • By Matthew R White
      My database is hosted in the cloud with Filemaker server and I have 12 FileMaker Pro users.
      I need help with a 2 page pdf document that gets generated with information for each client, sending that via API to docusign, and building a Docusign link that I can send to a customer to click and complete if they choose to with Docusign.
    • By omnia
      I am a canadian and I work with fmpAdvanced.
      if you find a solution, I'd appreciate you contacting me.
      <reply by private topic>
      I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.
      My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 
      Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.
      After this I will also need to be able to age the stock.  
    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
  • Create New...

Important Information

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