Forum Discussion
Date - Wrong year displayed (formatting problem)
Second formatting problem I cant solve today means second thread here today.. As earlier I seem to get stuck on getting the right format for my columns of the dataset. Im using Swedish settings on my...
ppm1
Solution Sage
Solution SageOne way to do it would be to keep it as text at first, then do a Text Before Delimiter step (transform tab, extract pull down) with a space as the delimiter. This will remove the 00:00:00 and you should be able to just convert it to Date type from there.
Pat
Thank you. It remove the 00:00:00 but still formats the year wrong.