Setting Column Default Values

Set String Column

To get the current year in a string default value:

=Text([Today],"yyyy")
  

Set DateTime Column

Setting calculated value to =TODAY() gives you 8/2/2018 12 AM 00.

Setting calculated value to =NOW() gives you 8/2/2018 8 AM 49.

Setting calculated value to =TODAY() + 1 gives you 8/3/2018 12 AM 00.

Setting calculated value to =NOW() + 1 gives you 8/3/2018 8 AM 49.

Setting calculated value to =TODAY() + 0.25 gives you 8/3/2018 6 AM 00.

Setting calculated value to =TODAY() + 0.33 gives you 8/2/2018 7 AM 55.

Setting calculated value to =TODAY() + 0.33333333 gives you 8/2/2018 8 AM 00.

Setting calculated value to =TODAY() + 0.34 gives you 8/2/2018 8 AM 09.

Setting calculated value to =TODAY() + 1.33333333 gives you 8/3/2018 8 AM 00.

Setting calculated value to =TODAY() + 1.72916667 gives you 8/3/2018 5 PM 30.

Setting calculated value to =DATE (2014, 7, 1) gives you 7/1/2014 12 AM 00.

View Master