Making text from a date (1 Viewer)

[fat controller]

I have a field that contains a date in dd/mm/yyyy format, and I need to use that to make a text string that is used elsewhere, in the reverse order. For example, today's date is 04/04/2017, so if that date was in the field, I would like my code to turn that into 170404, that will then go on to form part of a longer string.

Is this possible?

 

[Minty]

Yes use the format command ;
"YourString" & Format(YourField,"yymmdd")

 

[fat controller]

Ah, I thought there would be more to it than that - thank you