Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Time zone mismatches for orders #799

Open
smellsblue opened this issue Aug 17, 2021 · 1 comment
Open

Time zone mismatches for orders #799

smellsblue opened this issue Aug 17, 2021 · 1 comment

Comments

@smellsblue
Copy link
Contributor

The order date is stored in the database in UTC and reporting on the date needs to be Pacific time.

Either change order date to just be date and no time, or update relevant places (such as syncing to netsuite and reporting) to search/format based on Pacific time.

Double check with Lisa before we strip time from orders... probably best to keep the time.

@smellsblue
Copy link
Contributor Author

For example: this code in order exporting:

      invoice_record.tran_date = order.order_date.strftime "%Y-%m-%dT%H:%M:%S.%L%z"

Can sometimes push the order date to the wrong date because it is UTC.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant