Forum Discussion

Martin DeTerwangne's avatar
Martin DeTerwangne
Copper Contributor
Mar 01, 2018

Calculated field

Hi all, I would like to create a Status column on a list. It would give a status IN or OUT depending on conditions :  If there is no checkOutTime, it has to check if the checkin datetime is today...
SharePoint Online
Martin DeTerwangne's avatar
Martin DeTerwangne
Copper Contributor
Mar 01, 2018

Could someone help me please ? 

  • Paul Hunt - Cimares's avatar
    Paul Hunt - Cimares
    MVP
    Mar 01, 2018

    Hi Martin,

     

    I don't believe calculated columns are able to support the TODAY function, so there's no easy way of comparing the date in the column with todays date.

     

    Paul.