[Date/Time] Compare Dates with Formatting API on Daily schedule from Schedule API

Pipedream makes it easy to connect APIs for Formatting, Schedule and 1400+ other apps remarkably fast.

Trigger workflow on

Daily schedule from the Schedule API

Next, do this

[Date/Time] Compare Dates with the Formatting API

No credit card required

▶

Watch us build a workflow

7 min

Watch now ➜

Trusted by 500,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Schedule trigger and Formatting action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the Daily schedule trigger
1. Connect your Schedule account
2. Configure Cron Schedule
Configure the [Date/Time] Compare Dates action
1. Connect your Formatting account
2. Configure Start Date
3. Optional- Select a Input Format
4. Configure End Date
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

Daily schedule on Schedule

Description:Trigger your workflow every day.

Version:0.0.1

Key:schedule-daily

View on GitHub

Schedule Overview#

With Schedule - A trigger provided by Pipedream - You can easily build
automated workflows that run on regular times or intervals. Some examples of
things that you can build using the Schedule API include:

Automated data retrieval from a third-party service, like pulling stats from
your Salesforce account on a set schedule.
Uploading new data sets to a database with a predetermined interval.
Automatic emails to customers or leads at a certain time of the day.
Automating data analysis based on a set schedule.
Automatically optimizing social media postings according to a specified
timeline.
Updating webpages at a certain interval with newly available content.
Re-running reports on a periodic basis.
Refreshing a cache of data at a given frequency.

Trigger Code#

import schedule from "../../schedule.app.mjs";

export default {
  name: "Daily schedule",
  version: "0.0.1",
  key: "schedule-daily",
  type: "source",
  description: "Trigger your workflow every day.",
  props: {
    schedule,
    cron: {
      propDefinition: [
        schedule,
        "cron",
      ],
      default: {
        cron: "0 11 * * *",
      },
    },
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Schedule	`schedule`	`app`	This component uses the Schedule app.
Cron Schedule	`cron`	`$.interface.timer`	Enter a cron expression

Trigger Authentication#

The Schedule API does not require authentication.

About Schedule#

Trigger workflows on an interval or cron schedule.

Action#

[Date/Time] Compare Dates on Formatting

Description:Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

Version:0.0.2

Key:formatting-compare-dates

View on GitHub

Action Code#

import { defineAction } from "@pipedream/types";
import commonDateTime from "../../common/date-time/commonDateTime.mjs";
import app from "../../app/formatting.app.mjs";
import { DATE_TIME_UNITS } from "../../common/date-time/dateTimeUnits.mjs";
export default defineAction({
    ...commonDateTime,
    name: "[Date/Time] Compare Dates",
    description: "Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.",
    key: "formatting-compare-dates",
    version: "0.0.2",
    type: "action",
    props: {
        ...commonDateTime.props,
        inputDate: {
            propDefinition: [
                app,
                "inputDate",
            ],
            label: "Start Date",
            description: "Enter start date string, in the format defined in `Input Format`. If the start date is after the end date, these dates will be swapped and in the output `datesSwapped` will be set to `true`.",
        },
        endDate: {
            propDefinition: [
                app,
                "inputDate",
            ],
            label: "End Date",
            description: "Enter end date string, in the format defined in `Input Format`. Timezone is assumed the same for both dates if not explicitly set.",
        },
    },
    async run({ $ }) {
        const startDateObj = this.getDateFromInput(this.inputDate);
        const endDateObj = this.getDateFromInput(this.endDate);
        const startValue = startDateObj.valueOf();
        const endValue = endDateObj.valueOf();
        const datesSwapped = startValue > endValue;
        let result = "equal";
        let remainingValue = Math.abs(endValue - startValue);
        if (remainingValue) {
            const arrResults = [];
            const arrUnits = Object.entries(DATE_TIME_UNITS).sort((a, b) => b[1] - a[1]);
            for (const [word, unit,] of arrUnits) {
                const amount = Math.floor(remainingValue / unit);
                if (amount) {
                    arrResults.push(`${amount} ${amount === 1
                        ? word
                        : `${word}s`}`);
                    remainingValue %= unit;
                    if (!remainingValue)
                        break;
                }
            }
            result = arrResults.join(", ");
        }
        $.export("$summary", "Successfully compared dates");
        return {
            datesSwapped,
            result,
        };
    },
});

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Formatting	`app`	`app`	This component uses the Formatting app.
Start Date	`inputDate`	`string`	Enter start date string, in the format defined in `Input Format`. If the start date is after the end date, these dates will be swapped and in the output `datesSwapped` will be set to `true`.
Input Format	`inputFormat`	`string`	Select a value from the drop down menu:`{ "label": "Sun Jan 22 23:04:05 -0000 2006", "value": "ddd MMM DD HH:mm:ss Z YYYY" }{ "label": "January 22 2006 23:04:05", "value": "MMMM DD YYYY HH:mm:ss" }{ "label": "January 22 2006", "value": "MMMM DD YYYY" }{ "label": "Jan 22 2006", "value": "MMM DD YYYY" }{ "label": "2006-01-22T23:04:05-0000", "value": "YYYY-MM-DDTHH:mm:ssZ" }{ "label": "2006-01-22 23:04:05 -0000", "value": "YYYY-MM-DD HH:mm:ss Z" }{ "label": "2006-01-22 23:04", "value": "YYYY-MM-DD HH:mm" }{ "label": "2006-01-22", "value": "YYYY-MM-DD" }{ "label": "01-22-2006", "value": "MM-DD-YYYY" }{ "label": "01/22/2006", "value": "MM/DD/YYYY" }{ "label": "01/22/06", "value": "MM/DD/YY" }{ "label": "22-01-2006", "value": "DD-MM-YYYY" }{ "label": "22/01/2006", "value": "DD/MM/YYYY" }{ "label": "22/01/06", "value": "DD/MM/YY" }{ "label": "1137971045", "value": "Unix time (seconds)" }{ "label": "1137971045000", "value": "Unix time (milliseconds)" }`
End Date	`endDate`	`string`	Enter end date string, in the format defined in `Input Format`. Timezone is assumed the same for both dates if not explicitly set.