Forum Discussion
Solved
Date TIme Change
Good morning and Happy New Year I have a data set that is in a ddmmyy time format but text which is loading from a csv. I am trying to convert this from UTC to local time +10 However I am...
- Read in the CSV document.
- Convert column data type to datetime using locale equals english-us.
- Add custom column for finish formula: [Start] + #duration(0,10,0,0)
- See if that gives you what you want
It converted my whole file to this
- Read in the CSV document.
- Convert column data type to datetime using locale equals english-us.
- Add custom column for finish formula: [Start] + #duration(0,10,0,0)
- See if that gives you what you want
Thanks heaps@!!!!!