Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 08 Apr 2014 at 2:05pm
trim({XXXBO_Hosp_Charges_.Admitt_Date})="" or isnull({XXXBO_Hosp_Charges_.Admitt_Date}) or
Date(Left({XXXBO_Hosp_Charges_.Admitt_Date},4) + '/' +
{XXXBO_Hosp_Charges_.Admitt_Date}[5 to 6] + '/' +
Right({XXXBO_Hosp_Charges_.Admitt_Date},2)) in {?From} to {?To}
Thanks! don't mean to be pain in the butt but I still get blanks "admit_dates" records for last year as well but this trims it down a better, for admit_date. anyway to modify this to get just the ones I am asking not the old records? Cause I am only running this for 2014.
Thanks again!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
