datetimepentahokettlesystem-information
Pentaho: Get System info - get previous month
As the title suggest, I would like to get the previous month using the given month from Get System Info. I used Get System Info step to get todays month and year, and from there I would like to get the previous month. This is so it would be dynamic and I can ran this any day and still get the correct filter rather than making a hard coded year and month. Is this possible? If so, how do I do that?
Solution
Here is how I did it. This is the overview
Here is the calculator:
And concatenate fields:
There is still a few loop hole on getting the previous month during January. But, that is how I did it.
- Why Joda DateTime gives different result than Java Date?
- checking java date with postgresql timestamp without timezone
- What's the difference between Instant and LocalDateTime?
- How can I convert a Unix timestamp to DateTime and vice versa?
- php convert datetime to UTC
- DateTime vs DateTimeOffset
- How to determine upcoming months relative to a given month in any calendar?
- Convert ISO 8601 string in UTC to local time - JodaTime is adding the opposite of local time zone
- Count the number of inclusive dates covered by a date period
- R calculate timestamp of earliest sequential prior message based on user ID of who sent message
- Does anyone know of a good JSON time server?
- Format a date using the new date time API
- convert a C# datetime object into Excel date format
- Calculate Python Enum each time when evaluated with datetime?
- Python datetime.now() with timezone
- ion datetime component persist value across different components
- R calculate timestamp of last message based on user ID of who sent message
- Reading back a datetime in sqlite3
- DateTimeParseException: Text cannot be parsed to a Duration
- Convert dateTime to date in dd/MM/yy format in java
- excel No of hours in a shift
- Determine if DateTime is in a given Date Range
- How can I account for summer time when adding hours to a DateTime base value in PowerShell?
- PHP MYQSL single insert statement to enter either NULL, or time as datetime value when INSERT statement uses variable?
- How to get the date and time values in a C program?
- How to get integer value of datetime in java?
- What is the Z ending on date strings like 2014-01-01T00:00:00.588Z
- How to parse strings to DateTime in C# properly?
- Trying to mock datetime.date.today(), but not working
- Best way to compare dates in Android