bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/TodayFormulaFunction.java

   1 package org.simantics.spreadsheet.solver.formula;
   2
   3 import java.time.LocalDate;
   4 import java.time.Month;
   5 import java.time.temporal.ChronoUnit;
   6 import java.time.temporal.Temporal;
   7
   8 import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
   9
  10 public class TodayFormulaFunction implements CellFormulaFunction<Long> {
  11
  12     private Temporal baseline = LocalDate.of(1899, Month.DECEMBER, 30);
  13
  14     @Override
  15     public Long evaluate(CellValueVisitor visitor, AstArgList args) {
  16         return Long.valueOf(ChronoUnit.DAYS.between(baseline, LocalDate.now()));
  17     }
  18
  19 }