convert date in script help

[#1]

Hi

Suddenly one of my datafields(which I cant change myself)is altered from showing the dateformat as

dd-mm-yyyy to showing my date as yyyy-mm-dd-hh-mm-ss-sssssssssssss

Please help to make it as dd-mm-yyyy

Something like

load

[DATE],

LEFT([DATE],10)dd-mm-yyyy as DATE

[puttemans]

Ha no, my bad, I did not put the correct format.

Date( Date#( DAGSDATO, 'YYYY-MM-DD hh:mm:ss.fffffff'), 'DD-MM-YYYY') as Date

[luciancotea]

Then your format is  'YYYY-MM-DD hh:mm:ss.fffffff'

[#4]

Hi All

with help from you all and the last from Lucian, at the top of discussion I tried this

Date( Date#( DAGSDATO, 'YYYY-MM-DD hh:mm:ss.fffffff'), 'DD-MM-YYYY') as Date

and it worked

Thanx a lot all