topic Re: Three columns a date in QlikView

Three columns a date

QUASAR — Wed, 25 Nov 2020 16:16:04 GMT

I load a .txt file, in every line there is a string with day, month, year and other words; I used "(mid (@2,9,2)) AS Date" to separate day, month and year. Now I have 3 columns day,month,year(with month converted from 'Jan' to 01, 'Feb' to 02 etc.) but I need a new column with complete date (DD/MM/YYYY).

Help me.

Thank You

Re: Three columns a date

Anil_Babu_Samineni — Fri, 02 Aug 2019 15:38:11 GMT

Can't you use them in concatenate format?

Date(Date#(Date&'/'&Month&'/'&Year, 'DD/MM/YYYY')) as Full_Date

Re: Three columns a date

QUASAR — Mon, 05 Aug 2019 13:12:24 GMT

now it's ok, thank you