DetailFromDate

DetailFromDate

Gets parts from a timestamp in another field (like year, quarter, ...) and format it according to the output format string.

Attributes
Name Description Required Min Max Allowed Values
seed Random number generator seed of this Element. Overrides default seeding behavior. no 0 1
name (Class)Name of this element. Used to identify plugin Class. Full name is required. Example: com.en.myPluginPackage.myPuginClass no 0 1
id Identification String of this element. May be used to uniquely identify a field within the children of an Element. no 0 1
Nodes
Name Description Required Min Max Allowed Values
endDate Content type: Date or property
End of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}
no 0 1
historicalEndDate Content type: Date or property
Sets a separate date range in case your historical range (range [0,1[ or in case 'historicalTimeIDsCount' is set [0,historicalTimeIDsCount[) differs from the normal range ([startDate, endDate]). The normal range will be used for the update parts of a table in that case.End of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}
no 0 1
startDate Content type: Date or property
Begin of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}
no 0 1
historicalStartDate Content type: Date or property
Sets a separate date range in case your historical range (range [0,1[ or in case 'historicalTimeIDsCount' is set [0,historicalTimeIDsCount[) differs from the normal range ([startDate, endDate]). The normal range will be used for the update parts of a table in that case.Begin of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}
no 0 1
inputFormat Content type: String
Date or time input format for 'startDate', 'endDate', 'historicalStartDate' and 'historicalEndDate'. Default format: yyyy-MM-dd HH:mm:ss. Format specification: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html
no 0 1
reference reference no 0 1
useFixedStepSize Content type: Boolean
If set to false (default), each date_n will be computed with: date_n = date_n-1 + random. If set to true, each date will have a distance of [startDate, endDate] / numberOfRows to its next date.
no 0 1
  • true
  • false
  • 0
  • 1
isFiscal Content type: Boolean
If set to true, half a year is added to the chosen date
no 0 1
  • true
  • false
  • 0
  • 1
disableRng Content type: Boolean
If set to true, instead of choosing a random date within the date range, use the the current row id as position marker to traverse the date range from start to end.
no 0 1
  • true
  • false
  • 0
  • 1
historicalTimeIDsCount Content type: Long
Number of timeID's treated logically as 'historical'. Logically historical timeIDs can have a different date/time range than 'normal' timeID's. For historical timeIDs the date/time range: [historicalStartDate, historicalEndDate] is used
no 0 1
outputFormat Content type: String
Date or time output format. Default format: yyyy-MM-dd HH:mm:ss. Format specification: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html
yes 1 1
gen Value Generator for this field no 0 1
  • pdgf.generator.MarkovChainText
  • pdgf.generator.AsReferenceChoice
  • pdgf.generator.WeightedListItem
  • pdgf.generator.DetailFromDate
  • pdgf.generator.BuildList
  • pdgf.generator.InsertIntoString
  • pdgf.generator.UUID
  • pdgf.generator.Probability
  • pdgf.generator.RandomString
  • pdgf.generator.Sequential
  • pdgf.generator.ConvertNumberToString
  • pdgf.generator.WeightedSubListItem
  • pdgf.generator.RandomListItems
  • pdgf.generator.Email
  • pdgf.generator.ActionDeleteIsAlsoUpdate
  • pdgf.generator.DoubleNumber
  • pdgf.generator.Permutation
  • pdgf.generator.Switch
  • pdgf.generator.ReferenceValue
  • pdgf.generator.ForFormula
  • pdgf.generator.PrePostfix
  • pdgf.generator.StaticValue
  • pdgf.generator.Hash
  • pdgf.generator.Padding
  • pdgf.generator.FormatString
  • pdgf.generator.DateTime
  • pdgf.generator.Id
  • pdgf.generator.LastChoice
  • pdgf.generator.MaskString
  • pdgf.generator.Null
  • pdgf.generator.AddRandomSeconds
  • pdgf.generator.RandomStringInRange
  • pdgf.generator.Formula
  • pdgf.generator.AbstractDecimal
  • pdgf.generator.FormatFloatingPoint
  • pdgf.generator.OtherFieldValue
  • pdgf.generator.RandomSentence
  • pdgf.generator.FormatNumber
  • pdgf.generator.Template
  • pdgf.generator.BigBenchReview
  • pdgf.generator.UpperLowerCase
  • pdgf.generator.For
  • pdgf.generator.Relative
  • pdgf.generator.RandomUniqeString
  • pdgf.generator.PermutationReference
  • pdgf.generator.UpdateActionType
  • pdgf.generator.FormatNumberAsDate
  • pdgf.generator.OldReferenceGeneratorDeprecated
  • pdgf.generator.DictList
  • pdgf.generator.ExtendedFormula
  • pdgf.generator.FormatDateAsNumber
  • pdgf.generator.If
  • pdgf.generator.GlobalRowNumber
  • pdgf.generator.LongNumber
  • pdgf.generator.UnsafeDistinct
2.6_#1486_b758 | 2016-05-24