Max Date of the Data

[Anonymous]

Hi,

How can I reflect maxdate in the table box? When I just select Date, it reflects the calendar date.

Thanks

[sunny_talwar]

In a table box or text box?

May be this:

=Date(Max(DateField)) in as text box object

[Anonymous]

Its the table box, I reflect 2017 though our data should be just until the current day

[sunny_talwar]

Try restricting your fact table to today's date in that case:

Where Num(Date) <= Num(Today());

[Anonymous]

Thanks Sunny I appreciate your help, but I am really very new with this so please bear with me. How can I do that?

[sunny_talwar]

Sure thing

Can you share your script here?

[Anonymous]

This is what I have

Binary RawData.qvw;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET MaxDate='Today()';

Dimensions:

LOAD * INLINE [_row

Tool

Date

Category

Application

];

Metrics:

LOAD * INLINE [_valueNo, _value

1, Effort (Hours)

2, Assigned

3, Completed

4, Work in Progress

];

Status:

LOAD * INLINE [_stat

Assigned

Completed

Work in Progress

];