Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 6 of 6

Thread: Time Zone / DateTime of Order

  1. 11-26-2009, 12:25 PM #1
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default Time Zone / DateTime of Order

    Is there any AppConfig setting to offset the order time, from the time on the server? Our v8.0.0.0 ML server is not in the same time zone as our staff, and it would be nice to have the orders timestamped different then the servers time zone. Yes we could change the servers time too, but I'm just checking to see if this functionality is already baked in.
  2. 11-26-2009, 02:56 PM #2
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    It is not already baked in. The time of the order is based on the time function in sql server and hence is based on the time zone of the db server.
  3. 12-01-2009, 10:08 PM #3
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default

    Can someone point me to the method which would be grabbing the time? I guess I'd just do a bit a date arithmetic at that point.
  4. 12-01-2009, 10:44 PM #4
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    To what transaction status would you like to offset the OrderDate (On Capture, On Order entry or On Authorized)?
  5. 12-02-2009, 08:29 AM #5
    Amazing is offline Senior Member
    Join Date
    Nov 2008
    Posts
    103

    Default

    Since we emply time constrains on orders (i.e. cutoff times for Next Day Air etc.) we are really only looking for the Order Time. Would be nice to do all of them but the Order Time is the one we really need.
  6. 12-02-2009, 06:53 PM #6
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    We, structurally speaking, the default value or binding of the OrderDate column is getdate(), you could simply change that to an expression like getdate()-(1). Offsetting it one day behind, see if that works for you...