How to format "start date" coming from google calender and Dialogflow in integromat?

Question

I am trying to set up a filter in integromat where i am putting the condition like this;

condition google calender free/busy- Time Min. is equal to dialogflow date_time.

Problem is date/time format from google calender is like :- April 2, 2021 3:00 PM and date/time format of dialogflow is like 2021-04-02T15:00:00+5:30.

so my condition is not fullfilling. i want both the date/time format to be same. How can i do this in integromat.??

Answer 1

I think you need to have a webhook and over the webhook compare the two dates. You can convert the date coming from Dialogflow to your desired format with this code.

// Get date-time string for calender
const dateTimeForCalander = (date, time) => {

    let year = date.split('T')[0].split('-')[0];
    let month = date.split('T')[0].split('-')[1];
    let day = date.split('T')[0].split('-')[2];

    let hour = time.split('T')[1].split(':')[0];
    let minute = time.split('T')[1].split(':')[1];

    let newDateTime = `${year}-${month}-${day}T${hour}:${minute}:00.000${TIMEOFFSET}`;

    let event = new Date(Date.parse(newDateTime));

    let startDate = event;
    let endDate = new Date(new Date(startDate).setHours(startDate.getHours()+1));

    return {
        'start': startDate,
        'end': endDate
    }
};