Formatting date in Survey123

[bobwright]

Greetings. I've read Ismael's post regarding this, but it doesn't address the specific question I have. I understand that using the type "date" results in 10/5/16 12:00, but I would really like it to be 2016/10/05 12:00 so I can sort properly on them (10/21/16 sorts before 10/5/16 for example). The type "datetime" results in 16/5/10 which doesn't help much either. Changing the date format in the Regional settings of Windows does not help any. Suggestions? Thanks.

[MaureenPeniuk]

Day month year, will work for us for now.

That is better than having the month in the middle at least.

Maureen

[MaureenPeniuk]

Both Canada and South America display as / year month day/ in the form.

In the on-line data table it reverts back to month day year and the am/pm

time.

Maureen

[FRSadmin]

Hello,

I am trying to get this to display seconds using `%h:%M:%S` but it will only show seconds as 00 in survey123...

Is there anyway to autofill the seconds part using the now() data?

[VictoriaDavis1]

I have a date question appearing as year only which is ${study_year}. The user can select what year the assessment was done in the past.

I want another question that is an integer, and autopopulates like:
int((today() - ${study_year}) div (1000 * 24 * 60 * 60 * 365.25))

It works fine in the app but when i publish it, it no longer works? What am I missing?

[SarahWhitton]

I am trying to format my date, for example if I select today's date, December 4, 2018 I get 1543899600000. I added a hidden line with a calculation, as follows, format-date(${ReportDate},'%d/%m/%y') . I would like to reference this new formatted date in a calculation, which will produce an email (shown below).

When I insert the hidden line for the format-date, I get an error.

[JamesTedrick]

Hi Sarah,

What is the error that you get after adding the hidden line?

[MichelleWilliamsERM]

Is it possible to get this to work? I'm getting the UGLY Number right now: 

type	name	label	calculation
select_one yes_no	BMPsRequired	New/Additional BMP Needed
text	BMPRepairStatusUGLY	BMP Repair Needed Date	if(${BMPsRequired}='Yes', now(), 'None')
text	BMPRepairStatus	BMP Repair Needed Date	format-date(${BMPRepairStatusUGLY},'%Y/%m/%d %H:%M')

[AmyHarrigan]

Is it possible to get the year format in a spinner appearance rather than in a tab to the before or after year?

[JamesTedrick]

Hi Corey,

Can you clarify a little bit?  The year appearance already act much like a spinner appearance:

Are asking for the forward/back areas to be separate buttons?

[AmyHarrigan]

Suppose I was looking to see if there was a way to display year the same way you would for time.