topic Convert a date into the numberic format (41000 number) in QlikView

Convert a date into the numberic format (41000 number)

cmccafferty — Wed, 02 May 2018 10:52:02 GMT

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

Re: Convert a date into the numberic format (41000 number)

tresB — Wed, 02 May 2018 10:54:04 GMT

Try like:

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

Re: Convert a date into the numberic format (41000 number)

cmccafferty — Wed, 02 May 2018 10:57:19 GMT

Amazing

Thank you so much!!