Notifications
Clear all
Topic starter
I want to create a parameter based upon DOCUMENT.CLINICALDATE but CR is not allowing me to link the two via Select Expert.
Help?
Posted : January 7, 2013 6:33 am
that's because ClinicalDate is stored as a number. you'll have to reverse engineer the parameter date to a number of the same format before you can use it for comparisons.
Posted : January 7, 2013 6:35 am
Topic starter
Okay, I have a new formula created that converts it to a date. How do I build a parameter for a formula value though?
Posted : January 8, 2013 1:58 am
sorry. you need to create a formula converting your parameter date into a number and then compare the clinicaldate to this formula in your select criteria.
Posted : January 8, 2013 2:07 am
you could also do it this way:
{DOCUMENT_1.CLINICALDATE} >= (DateDiff("d", #1/1/1960#, #1/1/2012#) * 24 * 60 * 60 * 1000000)
and {DOCUMENT_1.CLINICALDATE} < (DateDiff("d", #1/1/1960#, #1/1/2013#) * 24 * 60 * 60 * 1000000)
this compares for 1 year. change the parts in red to your begin/end parameters.
Posted : January 8, 2013 2:16 am
Topic starter
Could I point two parameters (start & end) to this formula like below? Then use Select Expert to filter to this new formula's value? Are the #'s required around the parameter identifier?
{DOCUMENT.CLINICALDATE} >= (DateDiff("d", #1/1/1960#, #({?Start})#) * 24 * 60 * 60 * 1000000)
AND
{DOCUMENT.CLINICALDATE} < (DateDiff("d", #1/1/1960#, #({?End})#) * 24 * 60 * 60 * 1000000)
Posted : January 8, 2013 3:13 am
take out the # (used to specify a date) and take out the () after the # and it should work.
Posted : January 8, 2013 3:43 am
I use the following formula
Convertdate
NumberVar ID := {DOCUMENT.CLINICALDATE};
NumberVar Sec := Truncate(ID / 1000000);
NumberVar Days := Truncate(Sec / 3600 / 24);
Date(DateTime(Date (1960,01,01 ) + Days, Time(0,0,0) + Sec));
Then it can be used in record selection formula as:
({@ ConvertDate}>=#10/01/2012# and {@ConvertDate}<=#31/3/2013#)
If dates are parameters record selection formula will be
({@ ConvertDate}>={?DateFrom} and {@ConvertDate}<={?DateTo})
Posted : January 18, 2013 6:18 am
Topic starter
Thanks all. I actually went with the below formula.
{@CDate} in {?StartDate} to {?EndDate}
Posted : January 20, 2013 10:16 pm
