This is an automated email from the ASF dual-hosted git repository.
hansva pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hop.git
The following commit(s) were added to refs/heads/master by this push:
new bb16d700ea removed yesterday function from formula plugin and docs.
fixes #2464
new 0ea6814236 Merge pull request #2473 from bamaer/2464
bb16d700ea is described below
commit bb16d700ea33146c3b52ea60112e7c17eba325c7
Author: Bart Maertens <[email protected]>
AuthorDate: Sat Feb 25 10:42:21 2023 +0100
removed yesterday function from formula plugin and docs. fixes #2464
---
.../modules/ROOT/pages/pipeline/transforms/formula.adoc | 17 -----------------
.../pipeline/transforms/formula/function/functions.xml | 17 -----------------
2 files changed, 34 deletions(-)
diff --git
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/formula.adoc
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/formula.adoc
index 41e7bbf980..0d91009678 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/formula.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/formula.adoc
@@ -728,23 +728,6 @@ Applications shall support extracting the year from a date
beginning in 1900. Th
|YEARFRAC("1/1/2012","7/30/2012",3) |0.57808219|Fraction between same dates,
using the Actual/365 basis argument. Uses a 365 day basis.
|===
-==== YESTERDAY
-
-|===
-|*description*|Return the serial number of the previous day
-|*syntax*|YESTERDAY()
-|*returns*|Date
-|*semantics*|This returns the previous day's serial number, using current
locale. This only returns the date, not the datetime value.
-|*constraints*|None
-|===
-
-*Examples*
-|===
-|expression|result|comment
-|TODAY()>YESTERDAY() |False|Every date YESTERDAY() changes, but we know it's
less than today.
-|INT(YESTERDAY)=YESTERDAY() |True|YESTERDAY() returns an integer. WARNING:
this test is allowed to fail if the locale transitions through midnight while
computing this test; because YESTERDAY() is referenced twice, in some
implementations this would result in a race condition) This is incredibly
unlikely to occur in practice.
-|===
-
=== Financial
==== PMT
diff --git
a/plugins/transforms/formula/src/main/resources/org/apache/hop/pipeline/transforms/formula/function/functions.xml
b/plugins/transforms/formula/src/main/resources/org/apache/hop/pipeline/transforms/formula/function/functions.xml
index ee3d51d1f0..d46d924277 100644
---
a/plugins/transforms/formula/src/main/resources/org/apache/hop/pipeline/transforms/formula/function/functions.xml
+++
b/plugins/transforms/formula/src/main/resources/org/apache/hop/pipeline/transforms/formula/function/functions.xml
@@ -3182,23 +3182,6 @@ System 2 The week containing the first Thursday of
the year is the first week
</examples>
</function>
-
-
-
- <function>
- <category>%Category.DateTime</category>
- <name>YESTERDAY</name>
- <description>Return the serial number of the previous day</description>
- <syntax>YESTERDAY()</syntax>
- <returns>Date</returns>
- <constraints>None</constraints>
- <semantics>This returns the previous day's serial number, using current
locale. This only returns the date, not the datetime value.</semantics>
- <examples>
- <example><expression>TODAY()>YESTERDAY()</expression>
<result>False</result> <level>1</level> <comment>Every date YESTERDAY()
changes, but we know it's less than today.</comment></example>
- <example><expression>INT(YESTERDAY)=YESTERDAY()</expression>
<result>True</result> <level>1</level> <comment>YESTERDAY() returns an integer.
WARNING: this test is allowed to fail if the locale transitions through
midnight while computing this test; because YESTERDAY() is referenced twice, in
some implementations this would result in a race condition) This is incredibly
unlikely to occur in practice.</comment></example>
- </examples>
- </function>
-
<function>
<category>%Category.DateTime</category>
<name>WEEKDAY</name>
