How to determine the number of years between two dates?

Question:

How to determine the number of years between two dates?

Answer:

Use calculated field and Datediff function. Here are some examples:

Number of years between two dates:

Datediff(year,datefield1,datefield2)

Number of months between two dates:

Datediff(month,datefield1,datefield2)

Number of days between two dates:

Datediff(day,datefield1,datefield2)

Contact Support

Leave a Reply

Shortlink to this page

Help Topics

Welcome to Caspio Online Help
▶Introduction to Caspio Bridge
- What is the advantage of using a Web Database?
- Why Use DataPages?
- Caspio Bridge Environment
- ▶Caspio Bridge System Requirements
  - Known Issues
▶Videos
- ▶Getting Started Videos
- ▶Full Implementation Videos
  - Social Networking Site
  - Event Calendar System
▶Tables
- How do I Create a New Table?
- About Data Types
- Importing Data
- Managing Data
- Modifying Tables
- Field Re-ordering in Table Design
- Table Relationships
- Lookup Tables
- Exporting Data
- ▶Scheduled Import/Export Tasks
▶DataPages
- ▶Creating DataPages
- ▶Form Elements
- Editing DataPages
- ▶Managing DataPages
▶Deployment
- ▶Deploying DataPages
  - Embed DataPages in the Webpage Header
- ▶SEO Deployment
  - SEO Deployment Guidelines
  - Sitemap Generator for Caspio SEO Deployments
- Block Access to DataPages by IP Address
- ▶Iframe Deployment
- Deploy Caspio DataPages in WordPress
▶Automatic Emails
- Acknowledgement Emails
- ▶Notification Emails
  - Troubleshooting Notification Emails
- File Attachments in Automatic Emails
▶Authentication and Security
- ▶Web User Authentication
- ▶Record Level Security
- Adding Encryption to DataPages
- Blocking Spam with CAPTCHA
- DataPage Folders
▶Styles and Formatting
- About Styles
- Creating a Style
- ▶Layout Options
  - Change the Default Alignment of Field Labels
  - Change the Button Cell Alignment
- ▶Border Options
  - Add Rounded Borders to Fields
- ▶Font Options
  - Design Using Google Web Fonts
  - Creating Glossy Heading Text
- ▶Advanced Style Options
- Exporting and Importing Styles
- Set the Width of a DataPage
- ▶Web Form Columns and Configurations Options
  - Adding Multiple Column Formatting to DataPage Sections
  - Adding Multiple Elements on a Single Line
- Styling for Advanced Reporting
▶Files and Images
- Uploading Files and Images
- Adding a Lightbox to View Images
- Referencing an Image Stored in Caspio Bridge
- Creating Thumbnails with the Image Resizer
▶Localizations
- ▶Creating a Localization
  - Arabic, Hebrew and Other Right-to-Left Languages
- Formatting and Rendering
- Format Types
- International Dates in Calendar Fields
- Exporting and Importing Localizations
- Customize Localizations to Improve Usability
▶Views
- Create a View to Filter a Table
- Creating a View to Join Tables
- Modifying Views
- Importing Views
- Exporting Views
▶Parameters
- Enable Parameters
- Displaying Parameters
- Passing Parameters through Caspio Bridge
- Passing Parameters Using a Query String
- Receiving Parameters
- Resetting Parameters
- Parameters in Dropdowns, Listboxes and Radio Buttons
- Creating Dynamic Labels
- ▶Parameters In Action
▶Account Management
- Account Alerts
- ▶Internal Users and Groups
- Backing Up Your Applications
▶Common Customizations
- ▶DataPage Interface Additions
- Create an Approval Process for New Records
- Hide Fields in DataPages
- Generate Link Menus and Pop-up Windows
- Dynamically Change the Background of a Results Page Record
- Create a Floating Feedback Tab
- Limit the Number of Maximum Submissions
- Vote Up – Vote Down Individual Records
- Create an Auto-Scrolling Record Viewer
- Add a Time Limit to Submission Forms
▶Extensions
- ▶Social Media
- ▶iPhone, iPad and Smartphone Solutions
  - In Action: Using the iPhone Kit
  - How to Add QR Codes to Your App
- ▶Caspio Bridge Plug-In for MS Office
  - Microsoft Office Plug-In (Office 2010)
  - Microsoft Office Plug-In (Office 2003-2007)
- ▶Maps
- Adding a PrintWhatYouLike Link
- Convert Existing HTML Forms to Submit Data to Caspio Bridge
▶Release Notes
- Caspio Bridge 7.2
- Caspio Bridge 7.1.5
- ▶Caspio Bridge 7.1
  - 7.1.1 Patch
- ▶Caspio Bridge 7.0
  - 7.0.1 Patch
  - 7.0.2 Patch
- Caspio Bridge 6.9.5
- Caspio Bridge 6.9
- What’s New in Caspio Bridge 6.9
- ▶Caspio Bridge 6.8
  - 6.8 Interface Changes
- Caspio Bridge 6.7
- Caspio Bridge 6.6
- Caspio Bridge 6.5
- Caspio Bridge 6.0
▶Tech Tips
- Tech Tip: Embed Documents in DataPages
- Tech Tip: Integrate Google Analytics into Submission Form DataPages
- Tech Tip: Dynamically Add Options to Dropdowns and Listboxes
- Tech Tip: Leverage the Power of Social Media in Your Apps
- Tech Tip: Optimize Your Web Forms for Maximum Usability
- Tech Tip: Custom Filter Elements
- Tech Tip: Creating a Floating Navigation Menu
- Tech Tip: How to Validate a User Email Address
- Tech Tip: Creating Collapsible Sections
- Tech Tip: Create Tabbed Navigation for Multiple DataPages
- Tech Tip: Adding a Zoom Window to Images
- Tech Tip: 5 Ways to Customize the Look of Your DataPages
- Tech Tip: 5 Techniques to Create Web 2.0 Style Design
▶Instant Apps
- Classified Ads
- Business Directory
- Vacation Requests
- Resource Scheduling
▼FAQ
- ▶DataHub
  - What IP address range Caspio is using for DataHub?
- ▶Authentication
- ▶Time and Date
  - How to eliminate Time from a Date dropdown?
  - Why Date Fields from Excel Import Incorrectly?
- ▶Map-Mashup
- ▶Deployment
- ▶Web Forms
- ▼Reports DataPages
- ▶JavaScript Issues
  - Why JavaScript is not working with multiple DataPages deployed on one page?
- ▶Auto Emails
  - Why acknowledgement emails are not received?
  - How Many Addresses are Allowed in Notification Emails?
- ▶API and Microsoft Office Plugin
  - How can I get Web Services API and Plug-in for Microsoft Office?
- ▶Styles and Localization
  - How to use an image as form background?
- ▶Errors and Messages
- ▶Security, SSL and Encryption
  - Can I use Caspio SSL without a website SSL?
  - Why I see no SSL lock icon for my web page?
- ▶Parameters
Sitemap

© 2011 Caspio, Inc. All rights reserved!

Sitemap | Terms of Use | Privacy Statement

Suffusion theme by Sayontan Sinha