Forum Discussion

SOE_Tech's avatar
SOE_Tech
Brass Contributor
Feb 01, 2023
Solved

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" ...
Document Library
SharePoint Online
Usage
  • SvenSieverding's avatar
    SvenSieverding
    Feb 02, 2023

    Hi SOE_Tech 

    I just tried it using that formula

    DATUM(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



RobElliott's avatar
RobElliott
Silver Contributor
Feb 01, 2023

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)

Resources