Date/time functions in Canvas apps are used to perform various operations on date and time values, such as adding or subtracting time intervals, extracting specific components of a date or time value, formatting date or time values, and more. These functions can be useful when working with date and time data in Canvas apps, such as displaying dates or times in a specific format, calculating the difference between two dates, or performing calculations based on specific time intervals.
Some examples of Date/time calculations functions in Canvas apps include:
- AddDays: Adds a specified number of days to a date value
- AddHours: Adds a specified number of hours to a date/time value
- AddMinutes: Adds a specified number of minutes to a date/time value
- AddMonths: Adds a specified number of months to a date value
- AddSeconds: Adds a specified number of seconds to a date/time value
- AddYears: Adds a specified number of years to a date value
- Date: Returns the current date value
- DateAdd: Adds a specified time interval to a date value
- DateDiff: Calculates the difference between two date values in a specified time interval
- DateValue: Converts a string to a date value
- Day: Returns the day component of a date value
- Hour: Returns the hour component of a date/time value
- Minute: Returns the minute component of a date/time value
- Month: Returns the month component of a date value
- Now: Returns the current date/time value
- Second: Returns the second component of a date/time value
- Text: Converts a date/time value to a string in a specified format
- Time: Returns the current time value
- TimeValue: Converts a string to a time value
- Today: Returns the current date value
- Weekday: Returns the day of the week component of a date value
- Year: Returns the year component of a date value
These functions can be used in various combinations to perform complex date and time calculations and manipulations in Canvas apps.