How to send NULL value in date field using mongoose and mongodb

Question

I am creating a user management module using express.js in which I have a field 'UserLastAccess' as Date in schema UserLastAccess: { type: Date} and calling Users.save() in post method.

I am unable to send null value in the above mentioned field using postman. I have tried so far "UserLastAcces": null, [], '' using body but nothing works. That field will have a date once user will be authenticated so thats why upon creation of User it has to go null.

You can skip that field altogether in the post request. Because I think you will be using new Date() in your logic when you set the date-time for that field. — Nayan
– Nayan, Commented Apr 30, 2020 at 17:44
Nayan, I am not setting new Date(). I think i cannot send null into a date field once its defined as type Date. — user342944
– user342944, Commented Apr 30, 2020 at 20:28
You can try default: undefined with the field if that works for you. — Nayan
– Nayan, Commented Apr 30, 2020 at 20:34
will try and to set date time format is there anyrhing builtin or ppl use libraries? — user342944
– user342944, Commented Apr 30, 2020 at 20:46
Explore moment very famous for handling date in JavaScript — Nayan
– Nayan, Commented Apr 30, 2020 at 20:47

Nayan · Accepted Answer · 2020-04-30 20:50:43Z

1

Few possible solutions are

Don't send the field in the post request and it will be ignored or set to any default defined in the schema
You can also set the default for the field as undefined so there will be no value initially

answered Apr 30, 2020 at 20:50

Nayan

6586 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to send NULL value in date field using mongoose and mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related