Failed to insert a null date using a microflow

0
Hi! Failed to insert a null date using a microflow I am using a microflow to insert data using DatabaseConnector and I get an error saving a date with null value. Where should I control this? When creating the variable o in the query?   Thank you!!
asked
3 answers
1

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.

answered
1

Hi,

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.

 

 

answered
0

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?

answered