# Anki .apkg export - meaning of due date number

**URL:** <https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974>\
**Category:** Help\
**Created:** [March 4, 2024, 8:02pm UTC](https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974 "2024-03-04T20:02:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![0FPM](https://avatars.discourse-cdn.com/v4/letter/0/b5e925/32.png) [@0FPM](https://forums.ankiweb.net/u/0FPM)\
**Post date:** [March 4, 2024, 8:02pm UTC](https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974/1 "2024-03-04T20:02:26Z")

</div>

Hi,  
This will be kinda technical.

I wanted to have some more ease and freedom in changing due dates in Anki, and I thought of opening the export .apkg (or colpkg, doesn’t matter) file in a SQL editor. The due date happens to be represented as an int number in the ‘cards’ table. An increase by one will move the card to the next day.

Question: What is the actual meaning of this number. In one deck the value for today is something like 400, and in the other over 2000. Why is that?

 ![Screenshot 2024-03-04 210126](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/3X/8/0/800ff3622571a657f310953193621b6272116efe.jpeg)

---

<div class="post-metadata">

**Author:** ![Danika\_Dakika](https://sea2.discourse-cdn.com/flex002/user_avatar/forums.ankiweb.net/danika_dakika/32/17815_2.png) [@Danika\_Dakika](https://forums.ankiweb.net/u/Danika_Dakika)\
**Post date:** [March 4, 2024, 8:36pm UTC](https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974/2 "2024-03-04T20:36:48Z")

</div>

I do hope you’ll be careful messing around with the database directly. You should _at least_ have a map – [Database Structure · ankidroid/Anki-Android Wiki · GitHub](https://github.com/ankidroid/Anki-Android/wiki/Database-Structure) – but it would also be good to know what you’re doing.

---

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/forums.ankiweb.net/abdo/32/654_2.png) [@abdo](https://forums.ankiweb.net/u/abdo)\
**Post date:** [March 5, 2024, 2:01am UTC](https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974/3 "2024-03-05T02:01:47Z")

</div>

For new cards, due is the position, which usually controls their order of appearance in the new study queue (the order also depends on the Display Order options).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/1X/8f1279ababc5879d54e4838989f606cfe55af8c7.jpeg) [@system](https://forums.ankiweb.net/u/system)\
**Post date:** [April 4, 2024, 2:02am UTC](https://forums.ankiweb.net/t/anki-apkg-export-meaning-of-due-date-number/41974/4 "2024-04-04T02:02:46Z")

</div>

Closed on April 4, 2024, 2:02am UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
