DateAdd
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
CF10
I'm sure I've done something wrong.
Any guidance is appreciated.
Thanks!
