• Home
  • Forums
  • FME Form
  • Transformers
  • 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.
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.

  • 17 November 2022
  • 2 replies
  • 3 views
F
Badge +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

 

icon

Best answer by ebygomm 17 November 2022, 14:28

View original
1 Attachment

2 replies

ebygomm
Rank
Userlevel 1
Badge +21

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
Badge +1

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

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
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.