Calculating Time Interval

[LQUCSF]

Hello, I'm wondering if someone can help me how to calculate a time interval on Filemaker Pro.

This is the problem: I have two dates and I want Filemaker Pro to calculate how many weeks there are between those two dates. I've tried it a few different ways, but I'm obviously doing something wrong because I get weird numbers every time. Help!

Thanks!

[LaRetta]

Calculation ( result is number) [color:blue]Case ( date1 and date2 ; ( date1 - date2 ) / 7 )

This will produce a decimal of whole weeks and partial remaining. You haven't said how accurate you want to be. If you only want full weeks, you can use:

[color:blue]Case ( date1 and date2 ; Div ( date1 - date2 ; 7 ) )

And welcome to FM Forums, LQUCSF!!! :smile2:

[LQUCSF]

Thank you for your help!