Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Featured Replies

In order to create calc for a second date 10 days earlier than a entered date in "date1", 9/20/2006, for example:

"date2" = ( DayOfYear ( date1 ) -10 )

as a "number" yields the value "253"

In a new calc "date3", the value "253" returned as a date yields 9/10/0001.

I see that the day and month are correct but the year is off.

What am I missing?

FileMaker stores dates as numbers starting with 1/1/0001, so a answer of 253 is equal to the 253rd day of year 1

All you need to do is to subtract 10 for your date (or add 10) and you will get the result.

c_date2 (calculation, date result) =

date1 -10

a date result will equal 9/10/2006 if the field contents of date1 is 9/20/2006

HTH

Lee

  • Author

Perfect -- that was so easy -- thank you:)

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.