getting the month and day in two digits

[wjburke2]

I am trying to return the month and day of two digit format. My user have a fill system that stores reports as
"\\apps\WEB\DMDOCSTMKNET\Inquiry Fulfillment Package Sheets\2009\Cycle 0413\Weekly report.XPS"

When I use this code I get a Cycle date of "413"
"\\apps\WEB\DMDOCSTMKNET\Inquiry Fulfillment Package Sheets\" & _
mm & "\Cycle " & Month(Date) & day(Date) & "\Weekly report.XPS"

"\\apps\WEB\DMDOCSTMKNET\Inquiry Fulfillment Package Sheets\2009\Cycle 413\Weekly report"

I assume that 4/7/2009 would be ...\Cycle 47\Weekly report.XPS" anyone know how to get this formated as MMDD?

 

[Scooterbug]

use the format function...


CycleDate = format(DateDesired,"mmdd")

 

[wjburke2]

Thanks that worked. I must have searched the WEB for an hour this morning and got nothing. I did find a reference to this at Google Book search Access 2000: The Complete Reference. They gave me everything except the how to use keyword “format”. Guess it wasn’t so complete. Thanks again

 

[Scooterbug]

no problem