Pull records for last 24 hours, time field changed from 20:01 to 2001

Here is the previous question & the answer:

I need to pull medication administration records for the previous 24 hrs.  
The Date and Time fields are separate and are in text form as 20110324 and 20:01.  
What syntax do I need to put in the record selector so I can pull records from the
previous 24 hours on demand?


(
Not IsNull({TABLE.DATE})
and
Not IsNull({TABLE.TIME})
and
IsTime({TABLE.TIME})
and
DateTime(Date(Val(Left({TABLE.DATE},4)), Val(Mid({TABLE.DATE},5,2)), Val(Right({TABLE.DATE},2)))+1,Time({TABLE.TIME})) >= CurrentDateTime
)
AND
(
({TABLE.DRUG} like "HYDROCODO*")
or
({TABLE.DRUG} like "MORPHINE*")
or
({TABLE.DRUG} like "HYDROMORO*")
or
({TABLE.DRUG} like "FENTANYL*")
or
({TABLE.DRUG} like "NARCAN*")
)

********************************************************************

Now I need the same info but the colon is left out of the time.  So the date and time are still separate but
are now like this:

20110324 and 2001

I thought I could adjust the code to accomodate the missing colon but after much frustration I am reaching out and hope
that the code can be adjusted easily.

Thanks,
LindaOKState