Combining two date fields in to one field from same table

[pinky1234]

Hi,

I have two date fields both are in  MM/DD format in one table and i have to merge those two date fields into one field and use the merged field for Slider.

For Example:

One date field have 01/01 to 12/29 and other date field have 01/02 to 12/29.There are some duplicates also.I have to combine these two date fields in to one field from same table.Please let me know if you have any questions.

Regards,

Pinky

[Anil_Babu_Samineni]

Is this not working?

Date1 & Date2 as DateField

[pinky1234]

Thanks for the reply.If i do Date1 & Date2 dates are coming like this 01/0201/03 for each date.Please find the attached screenshot so that you will understand the problem.Please let me know if you have any questions.

[ben_pugh]

Are you saying that every record has two date fields of "[from date] to [to date]" so for each record you have four dates in total and you want to combine them into a single field?

If so, a simple way would be to split each date field into 2 separate fields in the load, so you have 4 fields in total in QlikView - you could then perform calculations on these to get your final result.

[Anil_Babu_Samineni]

This case, You can load 2 times like

Load Date1 as DateField From T1;

Concatenate

Load Date2 as DateField From T2;

[hic]

You may need a Canonical Date

HIC

[pinky1234]

Thank you for the reply!

Every date has only one date like 01/02 but when i do Date1 & Date2 as anil suggested the dates are coming like attached screenshot. For example if Date1 has 01/02 to 06/25 and Date 2 has 05/02 to 12/30.So i wanted to combine like 01/02 to 12/30.Hope this helps.Let me know if you have any questions

Regards,

Pinky

[pinky1234]

Both the Date1 and Date2 fields are in same table.

[pinky1234]

Hi Henric,

Thanks for the reply,

How can Canonical date helps this problem.I wanted to merge two date fields in to one field use that field in same axis.

Note:Two date fields are in same table.

Can you please clarify or send us any sample qvw.

Regards,

Pinky

[Anil_Babu_Samineni]

Why not this?

Load Date1 as DateField From T1;

Concatenate

Load Date2 as DateField From T1;