Moment.js: find posts where someone commented today
I'm pretty new with moment.js. I have a notification page and on load I would like to display my posts where someone commented. I only want to see the posts where someone commented today. Can someone tell where I went wrong?
I have the following code:
I want to show all the posts where comments were placed on the local start of the day. Then I want to transform this date to UTC time because the mongoDB comment document got saved in UTC time as well.
// Generate the actual time
const todayForEvent = moment().startOf('day')
.utc().format();
console.log('todayForEvent', todayForEvent);
const posts = await Post.find({
// From this user...
$and: [
// Find normal posts that has comments (recent interactions)
{ _posted_by: userId },
{ comments: { $exists: true, $ne: } },
{ 'comments.created_date': { $gte: todayForEvent } }
]
})
console.log(posts);
this is how I save the date of the comment with Mongoose. What I want to do is save it in UTC time
const CommentSchema = new Schema({
created_date: {
type: Date,
default: moment.utc().format()
}
});
const Comment = mongoose.model('Comment', CommentSchema);
module.exports = Comment;
I did two console.logs and I'll add a screenshot of my database document as well
console.log(todayForEvent) returns 2019-01-02T06:00:00Z
console.log(posts) returns an empty array, so no matches were found
Database screenshot: as you can see below the format is 2019-01-02 12:26:23.000
javascript mongodb mongoose momentjs
asked Jan 2 at 19:22
tillytilly
394213
add a comment |
I'm pretty new with moment.js. I have a notification page and on load I would like to display my posts where someone commented. I only want to see the posts where someone commented today. Can someone tell where I went wrong?
I have the following code:
I want to show all the posts where comments were placed on the local start of the day. Then I want to transform this date to UTC time because the mongoDB comment document got saved in UTC time as well.
// Generate the actual time
const todayForEvent = moment().startOf('day')
.utc().format();
console.log('todayForEvent', todayForEvent);
const posts = await Post.find({
// From this user...
$and: [
// Find normal posts that has comments (recent interactions)
{ _posted_by: userId },
{ comments: { $exists: true, $ne: } },
{ 'comments.created_date': { $gte: todayForEvent } }
]
})
console.log(posts);
this is how I save the date of the comment with Mongoose. What I want to do is save it in UTC time
const CommentSchema = new Schema({
created_date: {
type: Date,
default: moment.utc().format()
}
});
const Comment = mongoose.model('Comment', CommentSchema);
module.exports = Comment;
I did two console.logs and I'll add a screenshot of my database document as well
console.log(todayForEvent) returns 2019-01-02T06:00:00Z
console.log(posts) returns an empty array, so no matches were found
Database screenshot: as you can see below the format is 2019-01-02 12:26:23.000
javascript mongodb mongoose momentjs
asked Jan 2 at 19:22
tillytilly
394213
1
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18
add a comment |
I'm pretty new with moment.js. I have a notification page and on load I would like to display my posts where someone commented. I only want to see the posts where someone commented today. Can someone tell where I went wrong?
I have the following code:
I want to show all the posts where comments were placed on the local start of the day. Then I want to transform this date to UTC time because the mongoDB comment document got saved in UTC time as well.
// Generate the actual time
const todayForEvent = moment().startOf('day')
.utc().format();
console.log('todayForEvent', todayForEvent);
const posts = await Post.find({
// From this user...
$and: [
// Find normal posts that has comments (recent interactions)
{ _posted_by: userId },
{ comments: { $exists: true, $ne: } },
{ 'comments.created_date': { $gte: todayForEvent } }
]
})
console.log(posts);
this is how I save the date of the comment with Mongoose. What I want to do is save it in UTC time
const CommentSchema = new Schema({
created_date: {
type: Date,
default: moment.utc().format()
}
});
const Comment = mongoose.model('Comment', CommentSchema);
module.exports = Comment;
I did two console.logs and I'll add a screenshot of my database document as well
console.log(todayForEvent) returns 2019-01-02T06:00:00Z
console.log(posts) returns an empty array, so no matches were found
Database screenshot: as you can see below the format is 2019-01-02 12:26:23.000
javascript mongodb mongoose momentjs
asked Jan 2 at 19:22
tillytilly
394213
I'm pretty new with moment.js. I have a notification page and on load I would like to display my posts where someone commented. I only want to see the posts where someone commented today. Can someone tell where I went wrong?
I have the following code:
I want to show all the posts where comments were placed on the local start of the day. Then I want to transform this date to UTC time because the mongoDB comment document got saved in UTC time as well.
// Generate the actual time
const todayForEvent = moment().startOf('day')
.utc().format();
console.log('todayForEvent', todayForEvent);
const posts = await Post.find({
// From this user...
$and: [
// Find normal posts that has comments (recent interactions)
{ _posted_by: userId },
{ comments: { $exists: true, $ne: } },
{ 'comments.created_date': { $gte: todayForEvent } }
]
})
console.log(posts);
this is how I save the date of the comment with Mongoose. What I want to do is save it in UTC time
const CommentSchema = new Schema({
created_date: {
type: Date,
default: moment.utc().format()
}
});
const Comment = mongoose.model('Comment', CommentSchema);
module.exports = Comment;
I did two console.logs and I'll add a screenshot of my database document as well
console.log(todayForEvent) returns 2019-01-02T06:00:00Z
console.log(posts) returns an empty array, so no matches were found
Database screenshot: as you can see below the format is 2019-01-02 12:26:23.000
javascript mongodb mongoose momentjs
javascript mongodb mongoose momentjs
asked Jan 2 at 19:22
tillytilly
394213
asked Jan 2 at 19:22
tillytilly
394213
asked Jan 2 at 19:22
tillytilly
394213
asked Jan 2 at 19:22
tillytilly
394213
asked Jan 2 at 19:22
tillytilly
394213
394213
1
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18
add a comment |
1
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18
1
1
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54012039%2fmoment-js-find-posts-where-someone-commented-today%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54012039%2fmoment-js-find-posts-where-someone-commented-today%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
It looks like you might need to save your dates in a different format, according to this question: stackoverflow.com/questions/2943222/…
– jmcgriz
Jan 2 at 19:43
You can delete the question as I already answered it here stackoverflow.com/questions/54015831/…
– Anthony Winzlet
Jan 3 at 8:18