Skip to main content

Accepted Date and Number Formats

For accurate & consistent data, only specific date & number formats are accepted. This prevents errors, import issues, & miscalculations

G
Written by Gemma - Plan A Support
Updated over a week ago

Date Formatting

All dates must follow the ISO 8601 standard:

  • YYYY-MM-DD β†’ e.g. 2023-06-30

βœ… When it comes to structuring your dates, the following structures are accepted.

  • YYYY-MM-DD

  • DD MMMM YYYY (e.g. 12 January 2023)

  • DD MMM YYYY (e.g. 12 Jan 2023)

  • DDth MMM YYYY (e.g. 12th Jan 2023)

❌ Avoid using:

  • 30.06.2023

  • 06/30/2023

  • 30/06/23

Note: If you're uploading from Excel or CSV, make sure date fields are formatted as text in YYYY-MM-DD format before importing.


Number Formatting

Numbers should be formatted using numeric values only and using a dot as the decimal separator (e.g. 25634.20).
​
πŸ”’ Accepted Number Formats

When entering numbers into the platform, please follow the international (English) format:

  • Use a dot (.) as the decimal separator

  • Do not use commas (,) to separate thousands or decimals in your input

βœ… Correct examples:

  • 1234.56

  • 9876543

  • 0.45

❌ Incorrect examples:

  • 1.234,56

  • 10.599.661

  • 1,234.56

Note: If you enter a number like 10599661 the system may display it as 10,599,661 for readability. This does not change the actual value β€” it's only for easier viewing.


πŸ’‘ Formatting Tips

  • Always use a dot (.) for decimal values

  • Never use commas (,) in number inputs

  • Avoid pasting numbers from Excel that include formatting or regional styles
    ​

Did this answer your question?