Straight Table with Just Today's Date

[#1]

Hi,

I'm trying to create a Straight Table with just today's date. My problem is that the dates I'm using are in a strange format:

Actual Start/End Date: 1YYMMDD

1150602 = 02/06/2015

In this example, I want to end up with a table that has just Run1's and Run2's (as they match in both tables) and only the results that will match today's date - in this case 4 results match 02/06/2015.

Scheduled Runs

Name	Description
Run1	ABC
Run2	123
Run3	XYZ
Run4	456

Actual Runs

Name	Status	Actual Start Date	Actual End Date
Run1	C	1150529	1150529
Run1	C	1150603	1150602
Run1	F	1150603	1150602
Run2	F	1150601	1150602
Run2	C	1150603	1150602
Run2	C	1150603	1150602
Run6	C	1150603	1150602
Run7	C	1150603	1150602

Any help is greatly appreciated.

Kind regards,

Tristan

[swuehl · Accepted solution]

Maybe like attached?

[maxgro]

actrun:

LOAD Name,

     Status,

     date(date#(right([Actual Start Date],6),'YYMMDD')) as [Actual Start Date],

     date(date#(right([Actual End Date],6),'YYMMDD')) as [Actual End Date]

FROM

[https://community.qlik.com/thread/166596]

(html, codepage is 1252, embedded labels, table is @2)

Where

date(date#(right([Actual Start Date],6),'YYMMDD')) = Today(1)

and [Actual Start Date] = [Actual End Date]

;

schrun:

inner Keep (actrun)

LOAD Name,

     Description

FROM

[https://community.qlik.com/thread/166596]

(html, codepage is 1252, embedded labels, table is @1);

[#4]

Thanks very much Swuehl, that's nailed it!

Kind regards,

Tristan