0

Trying to copy Date and Date + Time to new Field

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?

2 replies

null
    • Jim.5
    • 1 yr ago
    • Reported - view

    Never mind. I just went to the source CSV and did some regex until it would import correctly.

    • Fred
    • 1 yr ago
    • Reported - view

    You can do some regex in Ninox. But it is always better to have clean data to start with.

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 53Views
  • 2 Following