$function method help

[leonardo_ramirez_zaldivar]

hello, I am doing an aggregate query using $function to calculate a date and save it in another format

Order.aggregate([
  {
     $addfields: {
          newField: {
              $function: {
                 body: function(vistaDate){return moment(vistaDate).formato("YYYY-MM-DD")},
                arg: ["$vistaDate"],
                lang: "js"
            }
        }
    }
}
])

Error

MongoError: PlanExecutor error during aggregation :: caused by :: ReferenceError: _momentTimezone is not defined : body@:2:24

Thanks
L.

[steevej (Steeve Juneau)]

You should be able to do this with $dateToString.

This kind of cosmetic formatting are better if done in the client code. stateless client code is easier to scale.

[leonardo_ramirez_zaldivar]

Greetings, in my case $dateFromString is more adapted but it throws me the following error