{"id":32698,"date":"2022-09-30T15:01:31","date_gmt":"2022-09-30T09:31:31","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=32698"},"modified":"2025-01-16T11:44:25","modified_gmt":"2025-01-16T06:14:25","slug":"how-to-add-and-subtract-date-using-subtractfromtime-and-addtotime-functions-within-power-automate","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/09\/how-to-add-and-subtract-date-using-subtractfromtime-and-addtotime-functions-within-power-automate\/","title":{"rendered":"How to add and subtract date using subtractFromTime() and addToTime() functions within Power Automate"},"content":{"rendered":"

In this blog, let us see how we can add and subtract an \u2018x\u2019 time unit such as second, minute, hour, day, week, month, and year into and from the existing date.<\/p>\n

Requirement:<\/u><\/strong>
\nWe recently had a client requirement in which, the client wanted to calculate the next follow-up date for the current customer. This operation is performed when a new Customer (Account) is to be added to CRM and customer details are to be updated in the CRM.<\/p>\n

Solution:<\/u><\/strong>
\nTo achieve the above user requirement we designed a Power Automate<\/a> flow that triggers the creation and modification of an account. We used\u00a0the addToTime()<\/strong>\u00a0function for this. On firing this flow, the\u00a0CreatedOn<\/strong>\u00a0field of the account is read and the\u00a0addToTime()<\/strong>\u00a0function gets applied to it. The output value gets updated in the \u201cNext follow up\u201d file which is filled on the account form. Please find the below syntax for the function:<\/p>\n

Syntax:<\/p>\n

addToTime(DATE_TIME,INTERVAL,TIME_UNIT,OUTPUT_DATE_FORMAT)<\/p>\n

Where,<\/p>\n

    \n
  1. DATE_TIME_VALUE: It states the Date Time value in which the time is to be added<\/li>\n
  2. INTERVAL_TIME: It represents the numeric number that defines how many seconds, minutes, hours, days, weeks, months, and years are to be added to the date<\/li>\n
  3. TIME_UNIT: This defines which time unit (second, minute, hour, day, week, month, year) needs to be added to the existing date time<\/li>\n
  4. OUTPUT_DATE_FORMAT: It shows the string date format in which the output of the date is to be seen<\/li>\n<\/ol>\n

    Example:<\/p>\n

    Here, we can notice that one week is created on the field of Account entity and displayed on the account entity form:<\/p>\n

    addToTime(triggerOutputs()?[\u2018body\/createdon\u2019],1,\u2019Week\u2019,\u00a0\u2018dd-MM-yyyy\u2019)<\/em><\/strong><\/p>\n

    Output:<\/p>\n

    \"\"<\/p>\n

    Also, we can subtract second, minute, hour, day, week, month, and year from the existing date-time using the following-<\/p>\n

    subtractFromTime(triggerOutputs()?[‘body\/createdon’],1,’Week’,\u00a0‘dd-MM-yyyy’)<\/em><\/strong><\/p>\n

    On firing the Power Automate flow we get the following result-<\/p>\n

    \"\"<\/p>\n

    Conclusion:<\/p>\n

    Thus, in this manner, using subtractFromTime()<\/em><\/strong> and addToTime<\/em><\/strong> we can add or subtract second, minute, hour, day, week, month, or year time intervals from the existing date.<\/p>\n

    <\/strong>Accelerate Your Project Timeline with Our Dedicated Development Team! <\/strong><\/div><\/div><\/strong><\/p>\n

    Facing Dynamics 365 CRM or Power Platform resource constraints? Whether you need dedicated FTE developers<\/a>, outsourced development<\/a>, or offshore development centre support, we’re here to propel your project forward. Leverage our Microsoft Technologies expertise to meet deadlines and surpass expectations. Reach out to us at crm@inogic.com<\/a> for project success.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this blog, let us see how we can add and subtract an \u2018x\u2019 time unit such as second, minute, hour, day, week, month, and year into and from the existing date. Requirement: We recently had a client requirement in which, the client wanted to calculate the next follow-up date for the current customer. This\u2026 Read More: How to add and subtract date using subtractFromTime() and addToTime()\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,44,1985,2361],"tags":[],"class_list":["post-32698","post","type-post","status-publish","format-standard","hentry","category-microsoft-powerapps","category-power-apps","category-power-automate","category-technical"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t