X-Git-Url: https://gerrit.simantics.org/r/gitweb?a=blobdiff_plain;f=bundles%2Forg.simantics.spreadsheet%2Fsrc%2Forg%2Fsimantics%2Fspreadsheet%2Fsolver%2Fformula%2FTodayFormulaFunction.java;fp=bundles%2Forg.simantics.spreadsheet%2Fsrc%2Forg%2Fsimantics%2Fspreadsheet%2Fsolver%2Fformula%2FTodayFormulaFunction.java;h=61d4da3754b49a11f70eec1d7dded560bea0efb5;hb=5c67a96d34fe904b8c4b0375cd08ff1d543bf369;hp=0000000000000000000000000000000000000000;hpb=9a37dabc6c0212ed3e14499c88df3208cd06f9b0;p=simantics%2Fplatform.git

diff --git a/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/TodayFormulaFunction.java b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/TodayFormulaFunction.java
new file mode 100644
index 000000000..61d4da375
--- /dev/null
+++ b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/TodayFormulaFunction.java
@@ -0,0 +1,19 @@
+package org.simantics.spreadsheet.solver.formula;
+
+import java.time.LocalDate;
+import java.time.Month;
+import java.time.temporal.ChronoUnit;
+import java.time.temporal.Temporal;
+
+import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
+
+public class TodayFormulaFunction implements CellFormulaFunction<Long> {
+
+    private Temporal baseline = LocalDate.of(1899, Month.DECEMBER, 30);
+
+    @Override
+    public Long evaluate(CellValueVisitor visitor, AstArgList args) {
+        return Long.valueOf(ChronoUnit.DAYS.between(baseline, LocalDate.now()));
+    }
+
+}