Date function - Combining date item and time item into one - Pipedrive

How To
1

Product: Make
Module: Pipedrive

I would like to combine a date item “Next activity date” with a time item “Next activity time” in order to trigger the sending of a text message at the time of this activity. However the date and item are separate and I don’t understand how to put them together.

Example

Next activity date : 04-26-2022
Next activity time : 10:00:00
Desired output : 04-26-2022 10:00

Thanks in advance for your help.

Best

2

Here is the error message :
Failed to map ‘Date/heure envoi du sms’: Function ‘parseDate’ finished with error! ‘Mon Apr 25 2022 22:00:00 GMT+0000 (Coordinated Universal Time)10:00:00’ is not a valid date or does not match the date format.

You can find below how tried to do this

Capture d’écran 2022-04-26 à 12.19.20
Capture d’écran 2022-04-26 à 12.19.20864×498 36.1 KB

3

Use space variable instead of plus.

MSquare

4

I tried this but it is still not working. The plus signs are added automatically.

Capture d’écran 2022-04-26 à 13.00.42
Capture d’écran 2022-04-26 à 13.00.42862×404 37.6 KB

5

I see that this post is about a year old. I was looking for a solution to another problem, but might be able to help here in case anyone else stumbles upon this.

My guess is that you need to add the seconds into the format that you are parsing. DD-MM-YYYY HH:mm:ss

1 Like
6

Mate you’re almost there! follow these steps to have the green semphore and move on! the problem you are experiencing is due to the format you are using. use this function as follows:

Formatdate(10.next_activity_date; DD-MM-YYYY)+ 10.next_activity_time

2 Likes