Change order date to timestamp. : This will be fine if you are in...

Wed, 05 Mar 2014 01:36:41 +0000

Author: Guests
Subject: 5814
Posted: 05-March-2014 at 1:36am

This will be fine if you are in the US or using that date format and your server is also in the US.

To add the more detailed time stamp to the date in either format, simply append:

&TIME()

That is:

pDateOrder = pDateOrder &" "&TIME()

Change order date to timestamp. : I wanted to be able to see when...

Mon, 03 Mar 2014 15:52:56 +0000

Author: Brett
Subject: 5814
Posted: 03-March-2014 at 3:52pm

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

ProductCart Shopping Cart Software Forums : Change order date to timestamp.

Change order date to timestamp. : This will be fine if you are in...

Change order date to timestamp. : I wanted to be able to see when...