cognito-forms
I would like to use Cognito Forms to output the weekday of a calculated date in a specific language. However, when I use the formula DateTime.Today.DayOfWeek for example, it will always give me the day of the week in English, not in the language I have set in the form settings.
Is there some way I can make the form display a localized day of the week?
I am a developer for Cognito Forms. Currently we don’t allow for additional users within a single Cognito account. However, this is a feature we are actively working on and plan to add in an upcoming release, and you can follow its progress on our idea board. In the interim, you can set each specific form to send its entry notifications to one or more email address. This is under the Form Settings menu, and you can check the box to include entry details as well. This would allow other people in your organization to review the entries without having to log in. Hopefully this is a good workaround for your organization until we add multi-user support, but if there are additional features you’d like to see, you can use our request form.
I am one of the developers for Cognito Forms and will be glad to explain how to include Early-Bird rates on your forms.
In the Price field where you enter the amount, you can also enter calculations by starting with an "=". The online help provides details on different types of calculations, but here is the specific calculation that should work for your needs:
=DateTime.Today < "11/22/2014" ? 65 : 75
To explain, the "=" at the beginning lets Cognito know you are entering a calculation, not just a number. DateTime.Today will always return the current day. Comparing this to dates, in the format of "mm/dd/yyyy" in quotes will allow you to see if the day is before your cutoff date. Then the somewhat cryptic ? and : allow you to specify what the price should be if the date is before or after the cutoff date.
I hope this helps!
Best Answer
Dates and numbers are automatically localized in Cognito Forms whenever they are converted to text using the country and language settings for your form. The following example shows how to convert dates into localized text showing the day of the week and the month of the year.
Builder View
The Actual Form
Our help documentation on date calculations includes comprehensive examples for formatting dates and times as text:
https://www.cognitoforms.com/support/48/calculations/datetime-calculations