Text Parser - Date Passed Incorrectly?

[HelpMeLearn]

Your Task History ID

IjU3NjUwNTY4MDYzZjA0MzM1MjY1NTUzMTUxMzQ1MTZhNTQzMjBmMzMi_pc

I have a text parser that splits my data in order to get the date requested by our clients via a form submission. It's been without issues until lately where sometimes, it would give me a seemingly random number instead of the date parsed.

It looks okay in the actual parsing step:

It also looks okay when making an entry in the Google Sheet:

But it shows incorrectly in the Google Sheet entry:

I tried reselecting & remapping the date value from step 3. Sometimes, it shows the correct date. Other times, it is as above.

 

[Fagun Shah]

That is actually not a pabbly connect issue, you need to select the column in Gsheet where you passing the date and do this -

 

[Fagun Shah]

Or you can set as "Plain Text" as well.

 

[HelpMeLearn]

Or you can set as "Plain Text" as well.

Thank you for your reply.

I've had a look at your guide above, and my cells aren't set to number/date, etc. (which should be fine, since the format by default is text, and that's how I'd like my date to be).

For example:

August 13, 2025

Sometimes, it's inserted exactly as that (August 13, 2025). However, I've started to see random numbers these days.

The thing that makes it weirder is that task history showed the entry being made in the text format that it should be.

Any other clue?

 

[Fagun Shah]