Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hello Again guys, need help with this calculation/custom function please.

The output I am trying to achieve in a calculation is listed below

15-40500-72000-31500-project title

16-25200-72000-46800-project title

17-25200-72000-46800-project title

18-25200-72000-46800-project title

19-25200-72000-46800-project title

20-25200-42300-17100-project title

I have created a database with a start date and time, end date and time.

The start date and time field produces line number 1 which is

15-40500-72000-31500-project title

and the end date and time produces the last line which is:

20-25200-42300-17100-project title

I need a calculation to produce the filler dates in the range, typically the values

16-25200-72000-46800-project title

17-25200-72000-46800-project title

18-25200-72000-46800-project title

19-25200-72000-46800-project title

it is only the first bit of data that needs to change depending on how many days the user chooses. The 25200-72000-46800-project title will remain the same throughout till the last line. In my example the user chose from 15 of the month through to the 20th of the month. Is this possible?

This topic is 6275 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.