Date and Time format in 2 different fields

How To
,
1

Situation
I want to automate setting up a new deal in Pipdrive CRM based on an request per email (Gmail). I’m stuck on two topics

  1. How to get the right date format that I can send to the Pipedrive date field
  2. How to get the right time format that I can send to the Pipdrive time field (separate field!)

Screenshot 1 is the content of the Gmail input
image

Screenshot 2 is the Chat GPT output (text format)
image

I tried the parseDate format, but that doesn’t work (screen 3)

image
image433×132 8.08 KB

How to make this work

Question 2: How to get the time into the HH:MM format?

Thx in advance.

BR
Hugo

2

@Hugo_Haarman
Hi.

How to get the right date format that I can send to the Pipedrive date field

I think the date needs to be entered in the format described in the link below, and you may want to convert the date in ChatGPT.
https://www.make.com/en/help/mapping/date-examples

How to get the right time format that I can send to the Pipdrive time field (separate field!)

I think the tijd_event is in HH:mm format, is there some error outputting, I did a quick check of Pipedrive’s API docs and Time is a String type so it doesn’t seem to be a problem.

Best.

3

Yes, thx. Works. I already ask in the ChatGPT prompt for the right output and use JSON parser after that step.

2 Likes