Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Date Calculation help needed


jgm

Recommended Posts

Hi,

 

I'm looking for help. I am brand new to filemaker. I have started a database where I keep track of students who need to see a professional like a psychologist or social worker. I need to keep track of the date the student was referred to the professional and the date that they were first seen by that person.

 

My first question is how do I make a calculation field that will tell me how long the student waited to be seen (and if they aren't seen yet presume today's date for the calculation)?

 

I also need a second calculation (and maybe this is not possible) that would take the one longest wait for each kid and tally them into fields that are: 1 month or less, 2-4 months, 5-7 months, 8-10 months and more than one school year. Each kid can only be counted once (even if they see or are waiting to see multiple professionals) and I want it to be their longest wait time.

 

Thank you so much for your help!

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

Terms of Use