Parsing date to yyyy-mm-dd monday.com

Beginner Questions
, ,
1

:bullseye: What is your goal?

I’m using PDF.co. How do I send a date in the correct format so Monday.com saves it on a board?”

:thinking: What is the problem?

I’m using PDF.co. How do I send a date in the correct format so Monday.com saves it on a board?”

:test_tube: What have you tried so far?

I tried several options with ChatGPT, and the problem seems to be the JSON. I need help because it’s difficult to extract dates from a PDF using PDF.co and send them to a column in Monday.com.

3

Hey @JORGE_MOREJON

Monday.com date columns are picky, they need a specific nested JSON format with the date as "YYYY-MM-DD".

Here’s the fix:

Step 1: After your PDF.co module, add a Tools > Set Variable module:

  • Variable name: cleanDate

  • Variable value:

{{formatDate(parseDate(2.extractedDate; "MM/DD/YYYY"); "YYYY-MM-DD")}}

Replace "MM/DD/YYYY" with whatever format PDF.co is actually giving you.

Step 2: In your Monday.com “Create Item” or “Change Column Value” module, your date column JSON should look like:

{"date": "{{5.cleanDate}}"}

(Swap 5 for whatever module number your Set Variable is)

The gotcha: Monday.com expects that nested {"date": "..."} structure — just passing the date string alone won’t work.

A quick way to debug is to click your PDF.co module’s output and examine exactly how the date is returned. That tells you the right format string for parseDate().

Hope this helps.