我正在使用csvtojson npm包将csv数据导入mongodb，并且我正在获得验证错误：联系人验证失败：出生日期：值转换为日期失败"无效日期"；在路径"；出生日期"；，一年中的哪一天：值"强制转换为数字失败；NaN"；在路径"；一年中的哪一天"；错误
以下是我迄今为止所做的：
[
{
contactsalutation: 'Mr',
contactname: 'Jone White',
contactaddress: '456 Some Road',
contactnumber1: '12345678',
contactnumber2: '87654321',
contactemail: 'demo@demo.com',
contactdateofbirth: '23/01/1970',
contactremark: 'he is a very patient customer'
},
{
contactsalutation: 'Ms',
contactname: 'Jane doly',
contactaddress: '123 Some Other Road',
contactnumber1: '81234567',
contactnumber2: '81234578',
contactemail: 'demo@hotmail.com',
contactdateofbirth: '28/02/1970',
contactremark: 'she is also a very patient customer'
}
]
csvtojson()
.fromFile(csvFilePath)
.then(jsonObj => {
console.log(jsonObj);
jsonObj.forEach(items => {
const importContact = new Contact({
contactsalutation: items.contactsalutation,
contactname: items.contactname,
contactaddress: items.contactaddress,
contactnumber1: items.contactnumber1,
contactnumber2: items.contactnumber2,
contactemail: items.contactemail,
contactdateofbirth:new Date(items.contactdateofbirth),
dayoftheyear: (moment(new Date(items.contactdateofbirth)).format('YYYY/MM/DD') == '1900/01/01') ? '0' : moment(new Date(items.contactdateofbirth)).dayOfYear(),
contactremark: items.contactremark,
});
importContact.save()
})
})
这是模式的简短版本：
contactdateofbirth:{
type: Date,
default: '1900-01-01'
},
dayoftheyear:{
type:Number,
default: '0'},
我尝试使用新的日期，但未能转换到正确的日期。我在这里错过了什么？非常感谢您的帮助。再次感谢。
我知道我错过了什么>这是CSV 中的日期格式
[
{
contactsalutation: 'Mr',
contactname: 'Jone White',
contactaddress: '456 Some Road',
contactnumber1: '12345678',
contactnumber2: '87654321',
contactemail: 'demo@demo.com',
contactdateofbirth: '1970/01/23',
contactremark: 'he is a very patient customer'
},
{
contactsalutation: 'Ms',
contactname: 'Jane doly',
contactaddress: '123 Some Other Road',
contactnumber1: '81234567',
contactnumber2: '81234578',
contactemail: 'demo@hotmail.com',
contactdateofbirth: '1970/02/28',
contactremark: 'she is also a very patient customer'
}
]