Category: Design

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

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

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

This function subtracts a value in seconds from a specific time. For instance, assume you subtract 25 seconds from the 2:10:42 time by using the SUBSECONDS() function. When the SUBSECONDS() function is executed, it will return 2:10:17 as the value of time after it subtracts 25 seconds from the 2 hours, 10 minutes, and 42 seconds. You can use the SUBSECONDS() function as follows: To use the SUBSECONDS function: Note:- The 2:10:42 value specifies the time with 2 hours, 10 minutes,… Continue reading Subtract Seconds

This post describes two major activities related to the configuration of functions under the Date and Time category. The first activity includes steps to create an entity that contains values in date and time formats. The second activity describes how to use the entity in the date and time functions when you want to fetch… Continue reading Using Entity with Date and Time Functions

This function adds a specific number of years (for example, 2) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 2 years to the 05/03/22 (5 March, 2022) date. After you use the ADDYEARS() function to add 2 years to the 05/03/22 date, it performs the addition and then returns the 05/03/24 (5 March, 2024) date. You can use the… Continue reading Add Years

This function adds a specific number of months (for example, 5) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 5 months to the 05/03/24 (5 March, 2024) date. After you use the ADDMONTHS() function to add 5 months to the 05/03/24 date, it performs the addition and then returns the 05/08/24 (5 August, 2024) date. You can use the ADDMONTHS… Continue reading Add Months

This function adds a specific number of days (for example, 11) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 11 days to the 05/06/24 (5 June, 2024) date. After you use the ADDDAYS() function to add 11 days to the 05/06/24 date, it performs the addition and… Continue reading Add Days