Change order date to timestamp.

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I wanted to be able to see when Incomplete orders are appearing. It looks like SaveOrd.asp creates the initial incomplete order when a customer starts checking out.

'<<==== create date order var====>>
pDateOrder=Date()
if SQL_Format="1" then
     pDateOrder=Day(pDateOrder)&"/"&Month(pDateOrder)&"/"&Year(pDateOrder)
else
     pDateOrder=Month(pDateOrder)&"/"&Day(pDateOrder)&"/"&Year(pDateOrder)
end if

Right after that code I put this to overwrite the variable:
pDateOrder = now()

So far, it hasn't blown anything up. I just created an incomplete order and everything appears the same on the dashboard, but within the database I can actually see the time the incomplete order was created.

Has anyone done this before? Do you forsee any issues?

Edited by Brett - 03-March-2014 at 3:53pm