Question

Add days to date attribute with DateTimeCalculator

  • 18 May 2017
  • 1 reply
  • 23 views
ngstoke
Badge

Hello FME Users,

I have an attribute field (Planned Drilling Days) that has the number of days a drilling operation will take to complete. I'm trying to take these days and add them to the date the drilling operation starts (Spud/Frac Start Date) in order to determine on what date operations will be completed and populating a new attribute (Spud/Frac End Date). I've been trying the DateTimeCalculator but the results are being rejected.

Do I need to format the Planned Drilling Days first with DateFormatter (%d) before I send this into the DateTimeCalculator?

Thanks in advance for the help.

1 reply

ngstoke
Badge

Just got off chat with Safe. It was rejecting because I had it set to write to an attribute that was already created (Spud/Frac End Date) I had to create a new attribute in the Result to get it to populate.

I'm currently using FME 2017.0.1 Build 17288.

Safe informed me that this issue is fixed in the beta version of 2017.1

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.