Hi All,  I am facing a issue while loading date format in to MongoDB  , Below is the Date format(Highlighted in yellow)  expected in Mongo DB.

My map output card is build using Json Sample structure 

When i try to load data using map , i see data is loading as string.

Below is my element properties  ( When i am trying to load as Date , i am getting a error stating target type mismatch so i converted to Text and loading) 


There are no properties options available to change the data type to Date.

How can we build output card to identify this field as Date Type

FYI , When i query data from the same Mongo DB for a Valid Date type row , i see date is retrieved from Mongo DB Collection as Below using ITX Map . 

"auditHistory": [

                  {

                        "created": {

                              "$date": 1616686703457

                        },

                        "createdBy": "ESB",

                        "actionCode": "CREATE",

                        "actionDetails": "Created by ESB"

                  }

            ]

Is there a way we can handle the date correctly.

Hi All,  I am facing a issue while loading date format in to MongoDB  , Below is the Date format(Highlighted in yellow)  expected in Mongo DB.

My map output card is build using Json Sample structure 

When i try to load data using map , i see data is loading as string.

Below is my element properties  ( When i am trying to load as Date , i am getting a error stating target type mismatch so i converted to Text and loading) 


There are no properties options available to change the data type to Date.

How can we build output card to identify this field as Date Type

FYI , When i query data from the same Mongo DB for a Valid Date type row , i see date is retrieved from Mongo DB Collection as Below using ITX Map . 

"auditHistory": [

                  {

                        "created": {

                              "$date": 1616686703457

                        },

                        "createdBy": "ESB",

                        "actionCode": "CREATE",

                        "actionDetails": "Created by ESB"

                  }

            ]

Is there a way we can handle the date correctly.

Hi All,  I am facing a issue while loading date format in to MongoDB  , Below is the Date format(Highlighted in yellow)  expected in Mongo DB.

My map output card is build using Json Sample structure 

When i try to load data using map , i see data is loading as string.

Below is my element properties  ( When i am trying to load as Date , i am getting a error stating target type mismatch so i converted to Text and loading) 


There are no properties options available to change the data type to Date.

How can we build output card to identify this field as Date Type

FYI , When i query data from the same Mongo DB for a Valid Date type row , i see date is retrieved from Mongo DB Collection as Below using ITX Map . 

"auditHistory": [

                  {

                        "created": {

                              "$date": 1616686703457

                        },

                        "createdBy": "ESB",

                        "actionCode": "CREATE",

                        "actionDetails": "Created by ESB"

                  }

            ]

Is there a way we can handle the date correctly.

Hi All,  I am facing a issue while loading date format in to MongoDB  , Below is the Date format(Highlighted in yellow)  expected in Mongo DB.

My map output card is build using Json Sample structure 

When i try to load data using map , i see data is loading as string.

Below is my element properties  ( When i am trying to load as Date , i am getting a error stating target type mismatch so i converted to Text and loading) 


There are no properties options available to change the data type to Date.

How can we build output card to identify this field as Date Type

FYI , When i query data from the same Mongo DB for a Valid Date type row , i see date is retrieved from Mongo DB Collection as Below using ITX Map . 

"auditHistory": [

                  {

                        "created": {

                              "$date": 1616686703457

                        },

                        "createdBy": "ESB",

                        "actionCode": "CREATE",

                        "actionDetails": "Created by ESB"

                  }

            ]

Is there a way we can handle the date correctly.