Need to build text from columns that includes Date columns

[dntietz]

Hi all.
I am trying to create a Text statement that includes several columns in a spreadsheet, formatted in a certain way, to build a SQL statement from each row in the spreadsheet.
I'm running into a problem converting Date columns into Dates as text in the text cell.
I'm using the Concatenate method - which works well for numeric and text cells.

Here is my example Formula where column W is the date - and W2 equals 20-Dec-2021 -- which is what I want in my cell.

="("&B2&",'"&C2&"','"&D2&"',,'"&E2&"','"&F2&"','"&G2&"','"&H2&"','"&I2&"','"&J2&"',' ',' ',' ',' ',' ',' ',"&Q2&",'"&R2&"',' ','"&T2&"','"&U2&"',"&V2&",'to_date("&W2&",'dd-MON-yyyy')',"

I can't get any value but this ridiculous 44550 !! what?
How do i convert it back to 20-Dec-2021 or anything like that? 12/20/2021 would be fine but no... i can't get anything but 44550.

Please HELP!
Thank you!!

 

[Fluff]

Hi & welcome to MrExcel.
How about

="("&B2&",'"&C2&"','"&D2&"',,'"&E2&"','"&F2&"','"&G2&"','"&H2&"','"&I2&"','"&J2&"',' ',' ',' ',' ',' ',' ',"&Q2&",'"&R2&"',' ','"&T2&"','"&U2&"',"&V2&",'to_date("&TEXT(W2,"dd-mmm-yyyy")&",'dd-MON-yyyy')',"

 

[dntietz]

Thank you Fluff for your response!!
I got it working now!!!
Thank you SOOOOO Much!!

This is what I did...
..."&V2&",to_date("&TEXT(W2,"dd-mmm-yyyy")&",....

 

[Fluff]

You're welcome & thanks for the feedback.