I'm trying to change the date format from the default YYYY-MM-DD to DD/MM/YY but all my efforts are in vain. Ideally would like the display to look like DD/MM/YY, if not then the result.
I'm using the following under Calculation column.
You'll need to have a second calculate type question. The word "date" in the function needs to be changed to a data reference that pulls in the answer from your date type question. If you want the day and month to be zero-padded (that is, 06/07/18 instead of 6/7/18), then you'll want to change '%e/%n/%y' to '%d/%m/%y'. If you're using Microsoft Excel and it recognizes the cells as being dates, it may auto-format and you'll need to use the cell formatting options to adjust the appearance.
+===========+================+===============+====================================+
| type | name | label | calculation |
+===========+================+===============+====================================+
| date | my_date | Input a date: | |
+-----------+----------------+---------------+------------------------------------+
| calculate | formatted_date | | format-date(${my_date},'%d/%m/%y') |
+-----------+----------------+---------------+------------------------------------+
Also, welcome to the ODK forums! I'd be great if you could please take a minute to add a profile picture and introduce yourself.
Sorry for waking up this question but i have the exact same problem,
this is ok when we have date question in the form but what if i have hidden questions like:
Start - changed from 2018-09-16T16:46:38.945+04 to this: 16/09/18 16:35
End
Today - changed from 2018-09-16 to this: 16/09/18
i make this changes in form but still not working,
sorry, it's not formatted, but shortly, not format date comes in the field
in your submission, start is like this: 2018-09-17T09:24:16.878-04:00 but when i receive submissions on the latest version of ODK its like this: 19/09/18 13:06, same for end,
when I stuck in such troublesome situation, I searched a lot about the reason because of which I render this issue and best ways to resolve it. At that time, I have come to know that date formula not working in Excel issue arises due to following reasons. Here the reasons are:
Cause #1: Cells are formatted as text
Cause #2: The workbook is set to Manual calculation mode
• First of all, open the Excel worksheet
• Now make a right-click on the top of the Excel column and choose the Format Cells menu
• After choosing up the Format Cells, a Window of format cell will get open on your screen.
• Here, choose the Date option and select the date format that you needed for that particular column.
• Finally, make a tap on the OK option to save the format change and then close the Window.
follow this step you will surely be able to solve your date format problem in excel.