Category: Date and Time

Introduction This function subtracts one date from another date and returns a numeric value in seconds, such as 12 seconds, 25 seconds, or 43 seconds. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFSECONDS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFSECONDS function in… Continue reading Date Diff Seconds

Introduction This function subtracts one date from another date and returns a numeric value in minutes, such as 2 minutes, 5 minutes, or 10 minutes. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFMINUTES function can dynamically pick dates from attributes and elements. Use Cases The DATEDIFFMINUTES function can be used… Continue reading Date Diff Minutes

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

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

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

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

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

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

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

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