Skip to main content
Solved

Create interval in dates. The transformer doesn't accept ESRI:s dateformat. I've tried to convert it to fme_date but it still doesnt work.

  • November 17, 2022
  • 2 replies
  • 16 views
F
Forum|alt.badge.img+1

I have been given the task of creating an e-mail function. It should send an email when another date is about to expire. For example, a customer receives an email when there are 14 days left on their current booking.

 

But datetimecalculator does not work to calculate intervals of days when it comes from ESRI file geodatabase (is SDE in the original data)

 

I suspect it is the format of the attribute that is incorrect but can't find how to change it to a working date.

 

Is there anyone who can help me?

 

Attaching my workbench and a file geodatabase as a zip file

 

Best regards

Jesper

 

Best answer by ebygomm

The attributes you want to calculate the interval between need to be on the same feature, currently they are not which is why the workspace is failing

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3422 replies
  • Best Answer
  • November 17, 2022

The attributes you want to calculate the interval between need to be on the same feature, currently they are not which is why the workspace is failing

F
Forum|alt.badge.img+1
  • flugan87
  • Author
  • 25 replies
  • November 18, 2022

The attributes you want to calculate the interval between need to be on the same feature, currently they are not which is why the workspace is failing

thank! Works perfectly now

Community Stats

32,065
Posts
121,737
Replies
39,692
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.