I have 2 repeating tables. Each are from a different table in my SQL database. I can get the data to send from one to the other if there is no date involved but once I throw in a date field for both then it throws a "Conversion failed when converting datetime from character string." The field being sent from Table1 to the field in Table2 are both 'datetime' datatypes.
Here's the concept on how it works
Table 1
Date Added, Name, Dept fields
Table 2
Signup Date, Name, Dept, Add Trainee(check box) fields
Enroll button below Table 2 to move row to Table 1 for any check boxes under Add Trainee checked.
When the check box is checked and I click the enroll button that row of data should copy to Table 1 and refresh so that it shows up there. Once that happens the row of data that was copied is deleted from Table 2. Date Added just takes the current date. I want Signup Date to copy over to Table 1 even though it's not going to be shown so that if the person is removed from Table 1 back to Table 2 the Signup Date won't be blank.
Any suggestions would be very much appreciated.