2 Replies Latest reply on Apr 18, 2017 9:41 AM by bloodbanker


    bloodbanker Level 1

      I suspect it's a lot more simple that I'm making it.


      I want to add 48 hours to a date that is stored in a table.  I first query the database (MS SQL), then insert the new date into a different field in the same table.


      I tried this:

      <cfset good_until_date  = DateAdd('h', 48, good_date.cc_TIC_fridge_start)>


      The date that was in the database was:      2017-04-11 18:37:00.000  (this is the date I want to add 48 hour to)

      The new (wrong) date is from 6 days prior: 2017-04-05 17:52:00.000




      I'm sure I've done something wrong. 


      Any guidance is appreciated.