Combining Number field with Date() 1

[cschnable]

How do I have a form field display an existing number field with Date()

if The number field = 971 and I put
[Field]&"_"&Date() I get 971_7/16/2004

I want it to read out as 971_7_16_2004

Any help is appreciated - Thank you!

 

[scottian]

try this

=[MyNumber] & "_" & Format(Date(),"d") & "_" & Format(Date(),"m") & "_" & Format(Date(),"yyyy")

"My God! It's full of stars...

 

[cschnable]

Thank you for your help - I just figured it out - I used

=[MyNumber] & "_" & Format(Date(),"dd_mm_yyyy")

It worked fine