the formatDateTime() function will throw an error if the date is empty. You should check this in your microflow, and skip the formatting if the date does not exist.
Since you are using DB connector module, need to make sure in the server db, means in the Execute statement whatever the date format is there for date field, you need to follow the same in this microflow. Then only it will work.
Thanks to both!
So, if I have defined the attribute as Date and Time and I create it as a string variable to save it in sql like this:
How can I save it as Date in sql? Or how can I put an "IIf! = Null" inside the sql?