Getting closer.. but I need Date & Time (-60 days) in this format: 2015-06-01-00.00.00
I tried: <cfset theDate = #DateFormat(DateAdd('d', -60, now()),'yyyy-mm-dd')#-#TimeFormat(now(), "hh.mm.ss")#>
cfdump gives me: 24168
If I try: <cfset theDate = #DateFormat(DateAdd('d', -60, now()),'yyyy-mm-dd')#>
cfdump gives me:2011-06-19 (just need the time added..)
Ok, I have the working Time & Date finally!
<cfset theDate = #DateFormat(DateAdd('d', -60, now()),'yyyy-mm-dd')# & "-" & #TimeFormat(now(), "hh.mm.ss")#>
cfdump gives me the correct date & time: 2015-06-19-04.51.50
Thanks for the help.