If you came by our booth at DevCon, you likely saw our science fiction timeline. DayBack can now show multi-year projects on the Gantt Chart, and we created some long timelines to show how well this works. One plots when milestone SCIFI books and films were set, starting with Kepler’s Somnium in 1608. Check it out.

FileMaker Timeline

Make Your Own Timelines

You can make read-only URLs from any view in your calendar using DayBack’s sharing. Sharing is a great way to publish schedules to folks who can’t log into your FileMaker solution. The timeline above uses the new long timescales feature introduced as a free in-app update at DevCon. If you’d like to play with the timeline above, you can download a copy of DayBack with this SCIFI calendar already set up:

DayBack DevCon 2019 Demo

The latest version of DayBack, including calendars for the history of FileMaker (1985 – 2038) and Milestones in SCIFI (1608 – 21500).

Date Limits in FileMaker

FileMaker doesn’t support dates after the year 4000 (same with timestamps). Yet, we needed dates up to 21500 to put Dune on our timeline. Fortunately, DayBack does support dates this big, and when looking at FileMaker sources it converts all dates and timestamps to numbers. So, for the SCIFI timeline in FileMaker, we used text fields for dates and wrote a function to turn those into timestamp-numbers. This is tricky because while FileMaker’s date functions understand leap years, we couldn’t use any of those functions on text-dates that far in the future.

FileMaker 18 While Function

Fortunately, FileMaker 18 introduced the while function so we could have loops within our calculation to express the leap year rule ourselves. This is a very rough implementation we put together for DevCon. It only works with dates in the MM/DD/YYYY format, but it was fun to play with “while” and to see events 20k years from now.

This calc is included in the download above: in the fields DBk_TimestampStartCalcNum and DBk_TimestampEndCalcNum.

Tagged with →  

Leave a Reply

Your email address will not be published. Required fields are marked *

Share →
DOWNLOAD
DayBack Calendar
DayBack's 30-day trial is unlocked so you can customize it and integrate it with your files.
Download DayBack and we'll send you a couple short emails with tips on how to modify it and use some of the coolest features.
Thank you! Please download: DayBack Calendar
Need More?
SeedCode tips & example files in your inbox
Need More?
SeedCode tips & example files in your inbox
Want More?
Be the first to see articles and tips like these
DOWNLOAD
TimeZync
Download TimeZync and we'll send you a couple short emails with tips syncing your FileMaker Go files.
Thank you! Please download: TimeZync
Want More?
Be the first to see articles and tips like these