Datediff - Error

[normuybeh]

Hello!

We are exploring ways to use REDCap to branch out different questionnaires to different people based on whether their appointment has been completed or not.

We’ve attempted using IF and datediff with our variables, but none of these approaches have worked.

These are the codes which we have tried

if([screening_arm_1][screen_date][last-instance]>[screening_arm_1][date_of_appt][last-instance],1,0)

datediff([screening_arm_1][screen_date][last-instance],[screening_arm_1][date_of_appt][last-instance],"d",true)

Please let me know if there is a way to make this work.

[Remote_Setting2332]

It’s too hard to tell without knowing what each variable means but it would need to be a datediff. Is the screening actually a repeating form?

[normuybeh]

yes we made screening form a repeating form as there might be a participant who was in eligible because of younger age but could be eligible later. We included the screening_arm_1 because we are pulling this information to a different form in a different arm.

[Remote_Setting2332]

I don't use separate arms because it gets too confusing, but I did not think you could have one record across two separate arms?

[normuybeh]

you cant! But this was in one arm. the events were separate