Forum Discussion
Sharepoint 365 List - adding date
Hey everyone,
i am trying to create a really simple list showing all the contracts we have in a certain are.
The colums i am concentration on are
"Signed" (set as date format)
"Runtime" (set as number - in months)
"notice period" (set as number - in months)
"earliest termination" (set as date)
I now "just" want to add "Signed"+"Runtime"+"Notice period" which constantly runs into a "formular has a syntax error..." Whatever i write in the NEWLY created list comes up with that error.
German
=DATUM(JAHR([Unterzeichnet]),MONAT([Unterzeichnet])+[Kuendigungsfrist]+[Laufzeit],TAG([Unterzeichnet]))
English equivalent
=DATE(YEAR([Signed]),MONTH([Signed])+[Runtime]+[Notice Period],DAY([Signed]))
Am i missing something? I dont understand what the Syntax Error is (and even more why NOTHING indicates WHAT it is)
Greetings
Hi SOE_Tech
I just tried it using that formulaDATUM(JAHR([Unterzeichnet]);MONAT([Unterzeichnet])+[Kuendigungsfrist]+[Laufzeit];TAG([Unterzeichnet]))
If you did create your site in german, then you need to use semicolons (";") instead of commas ('",") as parameter seperators in your formulas (like in german Excel)
But strangely it does not seem to matter whether you use the english or german names of the commands, so this also works:Date(Year([Unterzeichnet]);Month([Unterzeichnet])+[Kuendigungsfrist]+[Laufzeit];Day([Unterzeichnet]))
Best Regards,
Sven
8 Replies
SOE_Tech That's strange, your English formula worked fine for me. Perhaps check the internal name of each column from the address bar when you hover over the column in List Settings.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Shouldnt that leave me with a different "error" as in "Column not found" or such?
I also checked the settings and how the field is called. The names are correctly spelled, Sharepoint is set to German.
I just tried to e.g. =[Runtime]+[NoticePeriod] in a new column (also set to number) and it gives me an error saying "the formular kann not use columns. In order to define a colum, that is based on another column, use a 'calculated column'"
I am completly lost now...Hi SOE_Tech
I just tried it using that formulaDATUM(JAHR([Unterzeichnet]);MONAT([Unterzeichnet])+[Kuendigungsfrist]+[Laufzeit];TAG([Unterzeichnet]))
If you did create your site in german, then you need to use semicolons (";") instead of commas ('",") as parameter seperators in your formulas (like in german Excel)
But strangely it does not seem to matter whether you use the english or german names of the commands, so this also works:Date(Year([Unterzeichnet]);Month([Unterzeichnet])+[Kuendigungsfrist]+[Laufzeit];Day([Unterzeichnet]))
Best Regards,
Sven
