nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enter Dates without using Spinners?

KylaCupp_SBY

Hi,

My field crew has asked if there is alternative way to enter dates rather than using the year and month spinners? They're finding it especially cumbersome with birthdays and would like to be able to type it in. Is there an easy alternative like just typing the numbers for dates?

Has anyone had success with a work around? I've been trying to figure out a work around by concatenating integer fields like month, day, year and then converting it into a date field but having no luck. Is this possible?

Thanks,

Kyla

Najděte více příspěvků označených jako

Accepted answers

LaurenceTait

Should be fairly straightforward. You just need to make sure you constrain your inputs to appropriate values and bind the field type to date.

Form 6.xlsx

All comments

LaurenceTait

Should be fairly straightforward. You just need to make sure you constrain your inputs to appropriate values and bind the field type to date.

Form 6.xlsx

KylaCupp_SBY

Thank you so much @LaurenceTait that is exactly what I was looking for, I just missed the note step with binding the date field type!

I'm only having two small issues that are probably easy fixes:

1. The formatting seems a little wonky on every display in Survey123 Connect and mobile, squeezed farther left than other questions.

2. I'm getting the wrong day in the final date iteration (Tdate) in your case. I have a feeling it's something to do with the time but not sure what the solution would be here?

Thanks,

Kyla

Screenshot 2022-09-07 091201.png

Screenshot 2022-09-07 091419.png

LaurenceTait

The formatting I can't help with. I'm assuming it has something to do with the way the survey is set up. Try copying the fields from my sheet to a new sheet that you know displays correctly, and see what happens.

As far as the date problem, does it always return the previous day? Can you open the attached survey and let us know what the result is and whether all dates are the same and true to today's date? That should tell us where the problem is coming from.

Form 6.xlsx

KylaCupp_SBY

Starting from scratch and creating a new form using the first .xlsx you sent I have the issue:

When starting a new form using the latest .xlsx you sent I am still getting the same issue and the now() is true:

I've tried unsuccessfully to pull the UTC offset and account for that but I just haven't been able to make it work and I'm not sure that is even the issue.

Any suggestions would be helpful!

Thanks,

Kyla

LaurenceTait

Almost certainly an issue with the UTC offset.

Try the attached XLSX. If the ISO_date field works, use that formula in your survey.

Caveat. I can't be bothered to modify the calculation for part hour offsets. So if you are in one of those time zones that have half part hour offsets, the calculation will be out by up to 45 minutes Unless you are recording in the middle of the night, that won't be an issue for the date. If you are recording in the middle of the night and you work in a time zone with part hour offsets, you'll need to adjust the formula.

Form 6.xlsx

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.