torsdag den 14. juli 2016

Derived Column mmm date conversion

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE([DateColumn],"Jan","01"),"Feb","02"),"Mar","03"),"Apr","04"),"May","05"),"Jun","06"),"Jul","07"),"Aug","08"),"Sep","09"),"Oct","10"),"Nov","11"),"Dec","12")

Ingen kommentarer:

Send en kommentar