Min Max Date function

[tamilarasu]

Hi,

I am working on a file where i want to show the data based on date, month and year wise. I want to fetch the date from existing tables but i am not sure how to do that. I have tried the below code suggested by someone in forum, but it's not working as expected. Can anyone see the below attached file and let me know whether my data model is okay to fulfill the requirement. If not, please guide.

MaxMinDates:

LOAD Max(Datetmp) as MaxDate,

    Min(Datetmp) as MinDate;

LOAD FieldValue('%Date', IterNo()) as Datetmp

AutoGenerate 1

While IterNo()<=FieldValueCount('%Date');

LET vMinDate=FieldValue('MinDate', 1);

LET vMaxDate=FieldValue('MaxDate', 1);

!Many thanks in advance.

[tamilarasu]

Hi Rob,

Well spotted. Thank you and have a nice day all.

[tamilarasu]

Hi Daniel,

I have not tried this as the issue has bee solved already. Thank you anyway.