Hi all,
I am trying to pick up the numeric value of a date field (23-Dec-16 = 42727) and use the number in a concatenated field. The end result field is picking up another numeric field first, and then adding 23-Dec-16 on the end, instead of 42727.
Here's my code:
RegoValue is anything between 1 and 40, in this instance let's say 32Code:Me.DepartDate1 = Me.DepartDate Me.ManifestID1 = Me.RegoValue & "" & Me.DepartDate1
The result I want is .... 3242727
The result I get is....... 3223-Dec-16
Any help appreciated
cheers
Pete