Can someone explain why I cant seem to create Sharepoint item to a list which has column that is Datetime -type?
If i try to create item with the Datetime column filled with %Date% variable I get this error:
If I look at the error details it says in message "String was not recognized as a valid DateTime."
It seems like if I copy paste manually the %Date% value to sharepoints Datetime column it takes it with no problem.
And at least in my testing it seems like PADs Datetime -type variable is always in the same format: M/dd/yyyy H:mm:ss
In my sharepoint list it doesn't take the seconds or AM/PM so I was thinking that maybe I try to give the value in that format. But I don't really know any way to change Datetime format in PAD without changing it to string type.
If I just try to pass it the date as a string type it will clearly say the type must be 'Datetime' ( I disabled the text to datetime converting)
Any ideas? Or do I just need to create new Sharepoint date column which type is text?
