I am trying to create a "TripID" with the area of the trip and leave date. For example, say you are visiting the West on 7/5/02, I would like the TripID to become West070502.
I have tried DatePart("dd",me.BeginDate) and I get this error:
Run-time Error '5'
Invalid procedure call or argument.
I have also tried Format(me.BeginDate,"dd") & Format(me.BeginDate, "dd") & Format(me.BeginDate,"yy") and received 777.
Anyone know what my problem is?
Thanks in advance!
I have tried DatePart("dd",me.BeginDate) and I get this error:
Run-time Error '5'
Invalid procedure call or argument.
I have also tried Format(me.BeginDate,"dd") & Format(me.BeginDate, "dd") & Format(me.BeginDate,"yy") and received 777.
Anyone know what my problem is?
Thanks in advance!