[Date/Time] Compare Dates with Formatting API

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

Trigger workflow on

HTTP requests, schedules and app events

Next, do this

[Date/Time] Compare Dates with the Formatting API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

Create a workflow to [Date/Time] Compare Dates with the Formatting API. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

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
Select a trigger to run your workflow on HTTP requests, schedules or app events
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Integrations#

[Date/Time] Compare Dates with Formatting API on New Requests (Payload Only) from HTTP / Webhook API

HTTP / Webhook + Formatting

Try it

[Date/Time] Compare Dates with Formatting API on New Submission from Typeform API

Typeform + Formatting

Try it

[Date/Time] Compare Dates with Formatting API on Custom Events from Zoom API

Zoom + Formatting

Try it

[Date/Time] Compare Dates with Formatting API on New Submission (Instant) from Jotform API

Jotform + Formatting

Try it

[Date/Time] Compare Dates with Formatting API on New Custom Webhook Events from Stripe API

Stripe + Formatting

Try it

Details#

This is a pre-built, source-available component from Pipedream's GitHub repo. The component is 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.

[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.5

Key:formatting-compare-dates

View on GitHub

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.5",
    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,
        };
    },
});

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
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:`Sun Jan 22 23:04:05 +0000 2006January 22 2006 23:04:05January 22 2006Jan 22 20062006-01-22T23:04:052006-01-22T23:04:05+00002006-01-22 23:04:05 +00002006-01-22 23:042006-01-2201-22-200601/22/200601/22/0622-01-200622/01/200622/01/06Unix time (seconds) Eg. 1137971045Unix time (milliseconds) Eg. 1137971045000`
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.