Re: date - Qlik Community

ch_riadh · ‎2014-10-20

hi
How can i concatenate 2 dates already in the same table. REC_DATE and INV_DATE ?

PrashantSangle · ‎2014-10-20

Hi,

try like

REC_DATE &'_'& INV_DATE as NEW_DATE.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

its_anandrjs · ‎2014-10-20

Give this fields unique single name like

Load

REC_DATE,

REC_DATE as NewDateField

Load From tableName;

Concatenate

Load

INV_DATE,

INV_DATE as NewDateField

Load From tableName;

ch_riadh · ‎2014-10-20

but the REC_DATE and the INV_DATE are in the same table.

date

Related Topics