Start Date and End Date

[Muthu]

Hi Team,

In our Dashboard we have splitted the Master date to Month year day and time and dropped the master date.

I need to create a from date and to date using the same month year day and time.

When I have only date I followed approach used in this video and was able to achieve it.

Selecting Arbitrary Date Ranges

But after splitting the date I am not able to do the same.

Please help me

Thanks in advance.

Muthu

[settu_periasamy]

Hi Muthu,

is there any specific reason to dropped your master date?

or you can try to create the date using your month, day, year field with help of makedate() function..

[Muthu]

For Optimization part we have splitted the master date and took the year month and day.

[settu_periasamy]

Anyhow, you want the date right for your calculations, right?, then you can create the date using MakeDate function.

[vishsaggi]

Hi muthu,

As settu mentioned you can use makedate() function to get the date.

For start date and enddate try this and let us know.

Eg:

MasterTable:

Load *

        MonthStart(Date) As StartDate,

        MonthEnd(date) As EndDate;

Load Month, Year, Day,

        Makedate(Year, Month, Day) As Date

From <YourTableName> ;

Try this and let us know if it works.

Thanks,
V.

[vishsaggi]

Sorry missed comma.

After Load * keep a comma.

Load *,

        ....

Thanks,
V.

[Muthu]

Hi,

Thanks for your reply.

Is there any way I can do this without using the makedate function in edit script,

because makedate function in the script will again increase the size of the dashboard.

[settu_periasamy]

Hi Muthu,

if you want the start date and end date, you need create the date field in the backend/frontend.

is it possible to post the sample data and expected output? that would be easier to help you

[Muthu]

Hi Settu,

if I can achieve this in the front end please tell me what are the steps.

[settu_periasamy]

Hi Muthu,

Can you post the sample of your qvw and expected output?