Be able to set null for date input

[locopati]

Describe the bug
I want to clear the date that was set on a field

Steps to reproduce the behavior

1. Create a type with a date field that is not required
2. Create an instance of the type with a value in the date field and save it
3. Edit the instance and clear the date field
4. It cannot be cleared
5. Make a GraphQL request to clear the field
6. The request errors

Expected behavior
You can clear the field in the UI
The GraphQL mutation works

Code snippets

mutation UnsetDate($id: ID!) {
  updateYourType(input:{
    where:{
      id: $id
    },
    data: {
      date_field: null
    }
  }) {
    your_type { 
      id
      date_field
    }
  }
}

This returns "message": "Expected type Date, found \"\"; Date cannot represent an invalid date-string ."

System

• Node.js version: 13.7
• Yarn version: 1.22
• Strapi version: 3b19.5
• Database: Mongo 4.2.5
• Operating system: Arch Linux 4.19-97

Additional context
Add any other context about the problem here.

[derrickmehaffy]

Node.js version: 13.7

You are on an unsupported node version, please test on node 12/10.

[lauriejim]

Thank you @locopati for reporting this issue.
This is due to the format validation. Can you please investigate it and submit a PR to allow null
Thank you.

[richardgrey]

I think this works now, so the issue could be closed. At least I was not able to reproduce it.

[lauriejim]

This error still exist with MongDB.

[weidox]

Just encountered same issue, don't know if that's DB related though we're using MongoDB. Trying to unset date field via admin UI, finding no way.

[luisjuniorj]

This error still exist with PostgreSQL.

[arturaum]

This error still exist with PostgreSQL.

Any changes?

[lauriejim]

This issue has been mentioned on Strapi Community. There might be relevant details there:

https://forum.strapi.io/t/new-release-strapi-v3-1-7/256/1

[miniskylab]

Ran into this issue today.

• Node: 12.18.3
• Strapi: 3.2.4
• Database: SQLite
• OS: Windows 10 Pro

[smoothdvd]

This issue will be fired when you POST formData.

Content type has a non-required field, which type is 'date'.

Error: Invalid format, expected an ISO compatible date
    at parseDate (/Users/alexgao/Dev/find-missing-people/node_modules/strapi-utils/lib/parse-type.js:37:11)
    at parseType (/Users/alexgao/Dev/find-missing-people/node_modules/strapi-utils/lib/parse-type.js:89:14)
    at /Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/parser.js:12:14
    at /Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/mount-models.js:463:25
    at Array.map (<anonymous>)
    at mapper (/Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/mount-models.js:460:29)
    at Child.<anonymous> (/Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/mount-models.js:619:63)
    at /Users/alexgao/Dev/find-missing-people/node_modules/bookshelf/lib/base/events.js:101:64
From previous event:
    at Child.triggerThen (/Users/alexgao/Dev/find-missing-people/node_modules/bookshelf/lib/base/events.js:101:20)
    at Child.<anonymous> (/Users/alexgao/Dev/find-missing-people/node_modules/bookshelf/lib/model.js:1152:23)
    at processImmediate (internal/timers.js:461:21)
From previous event:
    at Child.<anonymous> (/Users/alexgao/Dev/find-missing-people/node_modules/bookshelf/lib/model.js:1060:10)
From previous event:
    at runCreate (/Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/queries.js:113:45)
    at /Users/alexgao/Dev/find-missing-people/node_modules/strapi-connector-bookshelf/lib/queries.js:53:34
    at /Users/alexgao/Dev/find-missing-people/node_modules/knex/lib/transaction.js:183:22
    at processTicksAndRejections (internal/process/task_queues.js:93:5)
[2021-05-13T06:59:20.415Z] debug POST /missing-person-notices (42 ms) 500

[MuizU]

Did anyone find a workaround in postresql?

[crazyfree]

today I got same problem.
There is existing data in the database for exam delivery_date = 2023-10-06 00:00:00.000000.
I use API to set it to null so I do set delivery_date = null.
All other fields get updated but delivery_date stay unchanged

[mootensai]

I think this issue should still opened because we still couldn't set date input to null by null value

[luisjuniorj]

Thats why i moved on... How many years to set a field to null? Em sex., 6 de out. de 2023 05:44, Yohanes Candrajaya < ***@***.***> escreveu:

…

I think this issue should still opened because we still couldn't set date input to null by null value — Reply to this email directly, view it on GitHub <#5777 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAK3QPBZUKUH7T2JIOBRGW3X57AH7AVCNFSM4MGUB3TKU5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCNZVGAZDCMRWGM4Q> . You are receiving this because you commented.Message ID: ***@***.***>

[amh092]

Im facing the same issue has anybody solved it ?