I imported some date info but noticed some lines have dates and other lines have date + time. Ninox couldn't seem to get the import correct in all cases.

So, I created a new field DATE+TIME and am trying to copy the current text field with the date or date + time into the new actual DATE+TIME field.

The text version of the date+time field is "theDate".

The new DATE+TIME field is "Weigh Date"

Example of dates in the text field is:

1/14/2017

Example of Date Plus Time in the text field:

1/2/2021, 5:00:52 PM

Below is one attempt I made at trying to update several fields at once.

Nothing happens when I execute this code.

let oldDates := select Weights
for theDate in oldDates do
    'Weigh Date' = theDate ;
end

--

Suggestions?