I need to get 12 hours ago from the current date time in date time format. After some searching i have the ability to get one day ago (below) however i would like to just specify 12 hours ago.
Example: current datetime is 2016-04-19 21:00 then get variable for 2016-04-19 09:00
Example: current datetime is 2016-04-19 10:00 then get variable for 2016-04-18 22:00
-*this is what i have for one day ago from current datetime, i'm not sure if i can build on it? -SET &CURR_DT_RAW=HCNVRT(HGETC(20,'HYYMDS'),'(HYYMDS)',20,'A20'); -SET &CURR_DT=HCNVRT(HADD(HGETC(20,'HYYMDS'),'DAY',-1,8,'HYYMDS'),'(HYYMDS)',20,'A20');This message has been edited. Last edited by: <Emily McAllister>,