How to count days elapsed since ship date? 1

[sammylieb]

I am new to filemaker pro. I have a text field that notes the shipping date of an item in my inventory. I want another text field to display the number of days that have elapsed since that ship date. I have implemented this code:

If(
GetAsText( Day(Get(CurrentDate)) - Day(Ship date) ) = "1";
GetAsText( Day(Get(CurrentDate)) - Day(Ship date) ) & " Day";
GetAsText( Day(Get(CurrentDate)) - Day(Ship date) )
)

This shows number of days that have elapsed, but doesn't work as the month changes. It's counting the days, but not calculating the count correctly as the month changes. How can I calculate this correctly?

Thank you very much.

Sam

 

[jaco8867]

Try using DayOfYear instead of Day function


John