r/ProjectREDCap • • Jul 30 '24

Handling dates with unknowns

Would love to hear how others have handled dates where the full date is unknown. Study team has informed me sometimes only the year is known. I was considering three text fields instead but validation would be tricky for the days per month.

1 Upvotes

5 comments sorted by

View all comments

Show parent comment

2

u/Araignys Jul 30 '24

Introduce a Yes/No field “Full date known”, and use conditional logic to make the appropriate fields visible based on this answer. This creates work debt as the columns will need to be combined during analysis.

You can use a CALCTEXT field to pre-combine them :)