How do I format a date in a formula result?

[lhazou]

I'm using the below formula:
=IF(J10="n",(CONCATENATE("id",J21,"_promo",J5,"_front_",L6,".jpg")),"")

In the result, I would like what L6 is to be formatted the same way as L6.

The formula returns:
id49_promoJockeyB2G1Bras_front_38986.jpg
What I would like it to return is:
id49_promoJockeyB2G1Bras_front_200600926.jpg

So how do I put in my formula how I want a number to be formatted?

 

[Von Pookie]

Use the TEXT function:

=IF(J10="n",(CONCATENATE("id",J21,"_promo",J5,"_front_",TEXT(L6,"yyyymmdd"),".jpg")),"")

 

[onlyadrafter]

Hello

try

=IF(J10="n",(CONCATENATE("id",J21,"_promo",J5,"_front_",text(L6,"yyyymmdd"),".jpg")),"")

 

[lhazou]

Awesome! Works perfectly, thanks guys!