"status": 400, "message": "The string was not recognized as a valid DateTime 1

“status”: 400, “message”: “The string was not recognized as a valid DateTime

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')

Here is what the above code is Doing:
1. The first line is the expression that will be used to create the new column.
2. The second line is the name of the new column.
3. The third line is the data type of the new column.
4. The fourth line is the expression that will be used to populate the new column.

The expression used to populate the new column is:

formatDateTime(addDays(‘1900-01-01’,add(int(items(‘Apply_to_each’)?[‘Date’]),-2)),’yyyy-MM-dd’)

Here’s what the above expression is doing:
1. The first part of the expression is:

addDays(‘1900-01-01’,add(int(items(‘Apply_to_each’)?[‘Date’]),-2))

Here’s what the above expression is doing:
1. The first part of the expression is:

int(items(‘Apply_to_each’)?[‘Date’])

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)?[‘Date’]

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression is doing:
1. The first part of the expression is:

items(‘Apply_to_each’)

Here’s what the above expression

Similar Posts