Jump to content

Search the Community

Showing results for tags 'date as record'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 2 results

  1. Toni

    Calendar

    Version 1.0.0

    83 downloads

    I created this solution because I wanted to have each day as a record. The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days. It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs. After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job. Any idea or contribution to make it better is welcomed. Thank you, Toni

    Free

  2. Calendar View File I created this solution because I wanted to have each day as a record. The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days. It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs. After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job. Any idea or contribution to make it better is welcomed. Thank you, Toni Submitter Toni Submitted 02/22/2018 Category Samples FM Version 12  
×
×
  • Create New...

Important Information

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