The Instructure Community will enter a read-only state on November 22, 2025 as we prepare to migrate to our new Community platform in early December. Read our blog post for more info about this change.
Good afternoon, PostGres SQL queries using Canvas Data 2 for the public table, submissions column, submitted_at field returns inaccurate dates.
Below is an example of the results of a submitted_at field for a student in a class. The top is null because the row was for a teacher and would not have submitted the assignment, the bottom row is for a student. The date of the submitted_at is in 2023, however, the class did not start until 2024.
Here are the details of the start date of the course:
Course Start Date
Course End Date
Is anyone else encountering this when using the submitted_at field in the submissions column in the public table of Canvas Data 2? I welcome any insights you may have to offer. Thank you so much.
Solved! Go to Solution.
Community helpTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign inTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign in