Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
For Optimization part we have splitted the master date and took the year month and day.
Anyhow, you want the date right for your calculations, right?, then you can create the date using MakeDate function.
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.
Sorry missed comma.
After Load * keep a comma.
Load *,
....
Thanks,
V.
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.
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
Hi Settu,
if I can achieve this in the front end please tell me what are the steps.
Hi Muthu,
Can you post the sample of your qvw and expected output?