Date formatting for upload 1

[jaw5]

I have a date formatted as mm/dd/yyyy date in a database and I need to extract it for an upload. How do I extract it as an 8 character numeric field? I've tried extracting the year,month,day - but when I try and concantenate, I get a sum rather than a string. HELP!!!!

 

[drlex]

Functions like MONTH() and YEAR() will return an integer; you'd either need to convert such to strings before concatenating them prior to reversion or multiply them before addition (i.e. YEAR(date)* 10000 + MONTH(date)*100 + DAY(date) will give you yyyymmdd numeric date)

soi la, soi carré