Introduction This function subtracts one date from another date and returns a numeric value in hours, such as 2 hours, 6 hours, 10 hours, or 15 hours. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFHOURS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFHOURS function… Continue reading Date Diff Hours
Category: Date and Time
Contains functions related to the date and time
Date Diff Months
Introduction This function subtracts one date from another date and returns a numeric value in months, such as 2 months, 5 months, 15 months, or 36 months. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFMONTHS function can dynamically pick dates from attributes and elements. Use Cases You can… Continue reading Date Diff Months
Date Diff Years
Introduction This function subtracts one date from another date and returns a numeric value in years, such as 2 years, 5 years, 15 years, or 24 years. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFYEARS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFYEARS function… Continue reading Date Diff Years
Current Date Time
Introduction This function gets the system’s or device’s date and time in a specific format. When you configure this function, you need to define the format of the date and time. Later, you can display the current date and time in the element on the application or store it in the attribute. Examples and Use… Continue reading Current Date Time
Days Dif From Now
Introduction This function calculates the time difference in days by performing the subtraction between the current day and the user-defined day. It picks the current day (date) from the user’s system or device (for example, laptop or mobile phone). The user-defined day can be a date that the user enters in the element, or the… Continue reading Days Dif From Now
Subtract Years
This function subtracts a specific number of years (for example, 2) from a date with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to subtract 2 years from the 05/03/24 (5 March, 2024) date. After you use the SUBYEARS() function to subtract 2 years from the 05/03/24 date, it performs the subtraction and then returns the 05/03/22 (5 March, 2022) date. You can use the SUBYEARS function… Continue reading Subtract Years
Subtract Days
This function subtracts a specific number of days (for example, 11) from a date with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to subtract 11 days from the 25/06/24 (25 June, 2024) date. After you use the SUBDAYS() function to subtract 11 days from the 25/06/24 date, it performs the subtraction and then returns the 14/06/24 (14 June, 2024) date. You can use the SUBDAYS… Continue reading Subtract Days
Subtract Months
This function subtracts a specific number of months (for example, 3) from the date with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to subtract 3 months from the 05/10/24 (5 October, 2024) date. After you use the SUBMONTHS() function to subtract 3 months from the 05/10/24 date, it performs the subtraction and then returns the 05/07/24 (5 July, 2024) date. You can use the SUBMONTHS… Continue reading Subtract Months
Subtract Hours
This function subtracts a value in hours from a specific time. For instance, assume you subtract 2 hours from the 4:10:34 time by using the SUBHOURS() function. When the SUBHOURS() function is executed, it will return 2:10:34 as the value of time after it subtracts 2 hours from the 4 hours, 10 minutes, and 34 seconds. You can use the SUBHOURS() function as follows: To use the SUBHOURS() function: Note:- The 2:34:33 value specifies the time with 2 hours, 34 minutes, and 33… Continue reading Subtract Hours
Subtract Minutes
This function subtracts a value in minutes from a specific time. For instance, assume you subtract 14 minutes from the 2:30:34 time by using the SUBMINUTES() function. When the SUBMINUTES() function is executed, it will return 2:16:34 as the value of time after it subtracts 14 minutes from the 2 hours, 30 minutes, and 34 seconds. You can use the SUBMINUTES() function as follows: To use the SUBMINUTES function: Note:- The 2:30:34 value specifies the time with 2 hours, 30… Continue reading Subtract Minutes