Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
I want to perform date calculations in the $addFields stage of the aggregation pipeline. This works with hard-coded multipliers but fails if I try to pass a value from a document.
No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that
you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice
sessions to improve your knowledge and scores.
manpreet
Best Answer
2 years ago
I want to perform date calculations in the $addFields stage of the aggregation pipeline. This works with hard-coded multipliers but fails if I try to pass a value from a document.
The MongoDB version is Atlas 4.0.6.
Given this document structure:
..this query works. Notice the (*4) multiplier in the $cond is hard coded.
The desired results are: