Answered

#7 - Add Checkout Screen and Forms to my canvas app - Date Due field formula failing

(1) Share

Report

Posted on by MS-16051132-0

Hello Everyone, I have an issue with the formula in video #7, shown at around 12 min for the Date Due field in Book loan check-out form: it is supposed to have a relation to the Date Loan Start and add 7 days to receive the Date Due. I entered the formula as shown on the training video, however it does not recognize the "SelectedDate" part of it and throws an error (shown on the screenshot). I suspect I must have done something incorrectly while setting up the Date Loan Start but I was following the video step by step and I don't see it. Can you help me resolve that? Thanks :)

Categories:

General Discussion

Book loan check-o...

All responses (2)

Answers (1)

Verified answer

timl 35,173 Super User 2025 Season 1 on at

Like (1)

Report

#7 - Add Checkout Screen and Forms to my canvas app - Date Due field formula failing

Hi @MS-16051132-0

I think the issue is that you've misnamed your dtpDateStartLoan date picker control.

In the screenshot that you posted, note how you've named the Form control dtpDateStartLoan as highlighted below.

The screenshot below is taken from the video. Notice how it retains the Form name 'Form1'.

The date picker control that you need to rename to dtpDateStartLoan will be the one that appears beneath the corresponding data card control.
stampcoin 2,179 on at

Like (1)

Report

#7 - Add Checkout Screen and Forms to my canvas app - Date Due field formula failing

@MS-16051132-0 Hi,

This looks strange for me. Normally it should be DefaultDate Not SelectedDate.

Please double check it...