Category: Design

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

This function adds a value in seconds to a specific time. For instance, assume you add 25 seconds to the 2:10:12 time by using the ADDSECONDS() function. When the ADDSECONDS() function is executed, it will return 2:10:37 as the value of time after it adds 25 seconds to the 2 hours, 10 minutes, and 12 seconds. You can use the ADDSECONDS() function as follows: To use the ADDSECONDS… Continue reading Add Seconds

This function adds a value in minutes to a specific time. For instance, assume you add 30 minutes to the 2:10:34 time by using the ADDMINUTES() function. When the ADDMINUTES() function is executed, it will return 2:40:34 as the value of time after it adds 30 minutes to the 2 hours, 10 minutes, and 34 seconds. You can use the ADDMINUTES() function as follows: To use the ADDMINUTES function:… Continue reading Add Minutes

This function adds a value in hours to a specific time. For instance, assume you add 10 hours to the 2:10:34 time by using the ADDHOURS() function. When the ADDHOURS() function is executed, it will return 12:10:34 as the value of time after it adds 10 hours to the 2 hours, 10 minutes, and 34… Continue reading Add Hours