Correct me if i'm wrong. u wanted to display max date by default in your multi-box/list-box object right? if so then try to do below steps,
Go to settings -->Doc. Properties -->Doc. event trigger select as "On Open" and add your date file like below screen short.
MaxDate.qvw 151.0 K
I finally came up with a script that does it:
date(date#(if(not isnull(Completed_Date),mid(Completed_Date,6,index(Completed_Date,' ',3)-6)&' '&right(Completed_Date,4)),'MMM DD YYYY'),'MM/DD/YYYY') as Access_Date,
I have an extract script that brings data from my database and creates qvd tables. I have created a dashboard which has its own extract script. Data is brought in from the qvd tables and are presented in the dashboard.
The above script is in my extract script to create qvd tables.
I have a script that creates a table called spt_audit_event where I bring in the "Access_Date" field. I am trying to use the max function in the same script,but it gives me a script error.
However when I create another table doing a resident load from "spt_audit_event" table , the max function works.
The script looks like this:
Date(Max(Access_Date)) As Access_Date
But the problem I have is "SPT_AUDIT_EVENT" table is correlated with another table "inactive_autofire_users_report" . I am having trouble correlating this table with spt_audit_event2. Is there a way I can use the max function in the same script where I am bringing the extract date?
I know this sounds very confusing. I cant figure out how to insert a file . I was wanting to upload my script file. Hopefully I am making some sense for you to figure out what I need.
I really appreciate all your help