Convert a date into the numberic format (41000 number)

[cmccafferty]

Hi,

Probably a simple one, but I'm trying to create a unique reference on a table. (Tour Code & Departure Date concatenation) so that it can be used in an excel document.

When I do my formula =[Tour Code] & [Departure Date] , I end up getting a result of "JAPAN01/08/2018". How do i change my expression to get a result like "JAPAN43313" ??

Thanks

[tresesco · Accepted solution]

Try like:

=[Tour Code] & Num(Date#([Departure Date] , 'DD/MM/YYYY'))

[cmccafferty]

Amazing

Thank you so much!!