Hello:
How do I loop through a collection of dates where some dates have null values.. My goal is to insert all dates in the collection into a database using execute sql. But my inserts fails when dates in the list are null
Thanks
+7
Hi Femi,
Do you get an error when working with the For Each loop and the collection? I think the right way would be to get all the values in a collection and then testing them one by one.
For Each
Run If a date = Null then
Set the value for that date to i.e. 1900/01/01
Write date to the database.
Let me know if this is not working like this for you.
Kind regards,
Francois
+1
Francois :
Am storing the dates from the collection in a date variable, and it does not have an option to check for null
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.