Value outside range error for integer entry

1

Project Name (if applicable, otherwise just type n/a)

TSARA Project_Lao_2025

Question

For age, height and weight data entry, the value outside range error had occurred despite the number entered was within the valid limits. And the data edition could not be proceeded after error page. When I check the details and form builder, min and max value is already set, and everything looks fine. Can you explain me why?

I confirm I have read the User Guide at docs.epicollect.net

on

I confirm I have searched for an answer in this community.

on

2

Could you kindly share an example, possibly with screenshots, illustrating the issue you’re encountering?

Your insights will greatly assist in understanding and resolving the problem.

Thank you.

3

issue 1
issue 12408Ă—1526 118 KB

issue 2
issue 22970Ă—1230 256 KB

Here are the pictures of issue.

4

Thank you. We’ve been able to reproduce the issue, so we’ll look into it further.

5

The issue should now be resolved, but please let us know if you experience anything different.

Thanks again!

6

Thanks. Yes, there is no “value outside range” error now.

1 Like
9

Hi, I cannot create new questions in the link. Why? I have few questions to ask you regardsing Epicollect5. The error showed that Sorry you cannot post a link to that host.

uploading question issue
uploading question issue2468Ă—1194 154 KB

10

Remove any links in your question and try again.

11

HI. I am still occurring the same error without having any links.

12

May I inquire here. My question is that after downloading my dataset as csv file, some date of format is changed from D/M/Y to M/D/Y in excel file. Why is it happened? I have to changed manually in excel file. How can I get the date format to be correct and consistent in all data entries?

13

The issue of some dates in your CSV file downloaded from Epicollect5 changing from D/M/Y to M/D/Y format when opened in Excel happens because Excel automatically interprets and reformats date values based on your system’s regional date settings or Excel’s default parsing rules.

This often causes inconsistent date formats and misinterpretation of the day and month positions, especially when dates look ambiguous (e.g., 06/07/2024 could be June 7th or July 6th).

To keep the date format consistent and avoid manual correction in Excel, you can follow these approaches:

Importing CSV with Date Format Control

  • Instead of opening the CSV by double-clicking, import it into Excel using Data > Get Data > From Text/CSV. This launches a wizard where you can specify the delimiter and importantly, set the data type of date columns to a specific format, ensuring dates are correctly interpreted without swapping day and month.

  • When importing, specify the file origin as Unicode (UTF-8) if applicable, and set the date columns explicitly to the desired format.

Use Power Query in Excel

  • Power Query lets you load and transform the data. You can specify the date format during import, fixing the inconsistency once and for all.youtube​

Adjust Excel Regional Settings (as a last resort)

  • Make sure your Windows regional settings or Excel locale settings reflect the D/M/Y format (e.g., set region to Italy or UK). This helps Excel interpret ambiguous dates correctly.​

Convert Dates to Text Before Saving as CSV

  • In Excel, convert your date column to text strings in the desired format (e.g., DD/MM/YYYY) using a formula like =TEXT(A1, "DD/MM/YYYY"). Save the file as CSV after this to avoid Excel reinterpreting dates​

Using Text to Columns for Correction

  • If some dates are misformatted after opening, select the column and use Excel’s Text to Columns tool, choosing the correct date format (MDY or DMY) in step 3 to fix mixed formats​

Important Note on Editing CSV

  • Even if the CSV file itself contains correct date text (check by opening in Notepad), Excel will reformat dates when opening normally. So always import or convert dates explicitly, or open CSV in a text editor to verify formats.​

By using one or a combination of these methods, you can automate correct date formatting and avoid manual fixes after downloading Epicollect5 CSV data. The key is to properly control how Excel interprets dates on import and/or convert dates to text before saving. This ensures your D/M/Y format remains consistent across all data entries.