Cognito-forms – How to calculate the week ending date based on a given date

cognito-forms

Week ends on Sunday. So today, Friday, has week ending date DateTime.Today.AddDays(2), correct?

And in general, if I calculate the number of days from the given date until the week ending date and assign it to DaysToWeekEnding (number value), then

DateTime.Today.AddDays(DaysToWeekEnding) , right?

Well I keep getting an error when trying to set the default value of a date field to the above. "No applicable method 'adddays' exists in type 'DateTime'. But if I replace DaysToWeekEnding with a literal number (e.g. 2), then the form builder accepts it as valid.

Please help me out of this loop, or let me know of another way to obtain a week ending date.

Best Answer

I think you specifically need to convert that number (DaysToWeekEnding) into an integer. So your calculation should look like this:

=DateTime.Today.AddDays(Int32.Parse(DaysToWeekEnding))

I hope this helps to get you out of that loop.

Related Solutions

Cognito-forms – How to calculate grand totals based on selected options in Cognito Forms

I believe I tracked down the form in question, so I can provide a couple of options to consider:

Whether you are collecting payment online or not (since this is a quote) you can specify that you want to collect payment based on options selected. You can collect payment using Currency (user fills in), Price (constant or calculated amount), Choice (user picks options with associated prices), and Yes/No (price associated with Yes response). Here is an example using this approach with a choice field set to collect payment:
If the first automatic option does not meet your needs, you can add a Calculation field, set the Type to Currency, and enter a calculation to add up the amounts for each of the payment-related fields on the form. For Yes/No and Choice fields, a special property is available when writing calculations to let you know the total amount based on selections. You can see that this will show up as an auto-complete option when you are writing your calculations:

Using this approach, here is an example of a Total calculation that adds the amount of a Base Price field with the total selected amounts from an Options field:

The calculation for the Total field in this example is =BasePrice + Options_Amount. You can do almost anything in calculations, including calculations that sum up values in repeating sections. For more information, check out our calculation help documentation.

Cognito-forms – Default Date based on Drop Down selection in Cognito Forms

I am a developer for Cognito Forms.

You are very close to getting the calculation to work, AddDays takes an integer value and the value and what you were generating is a decimal value. You will need to add a little extra code to your Due Date calculation to get it running correctly.

=DateTime.Today.AddDays(Int32(CalculatedTime))

One other change I would make to your calculation in the CalculatedTime field would be to remove the quotation marks (") from around the numebrs, so your calculation looks like this:

=ProjectType = "Flyer: Up to 30 Products" ? 7 : ProjectType = "Flyer: Up to 60 Products" ? 12 : ProjectType = "Flyer: 60+ Products" ? 18 : 7

Best Answer

Related Solutions

Cognito-forms – How to calculate grand totals based on selected options in Cognito Forms

Cognito-forms – Default Date based on Drop Down selection in Cognito Forms

Related Topic