Date Conversion error
SummaryGetting type/cast error when calculating Date 30 days before.
Hi - trying to get date 30 days before but getting error FORG0001: invalid value for cast/constructor. The Batch_Date is being read through a stage read activity and the csv schema already has the column type as date. Also tried to explicitly convert by putting it within xsd:date(). Still get the same error.
Expresion used: <xsl:value-of select = "$currLineReadFile/nsmpr1:readFileRecord/nsmpr1:Batch_Date - xsd:dayTimeDuration('P30D')">