Using FME to Populate Columns based on Account Expiring

You'll need to convert the AccountDate to an FME Date (e.g. 20190601), then you can use the DateTimeCalculator to calculate the difference between that and the current date, like so:

Thanks in regards to that issue it works for the date.

I have created 3 columns in the Attribute Manager.

Based on the date column, I am trying to populate if the account has less than 30 days remaining in a 90-day cycle. The parameters I have played with a few different dates but I am only getting a Yes output.

I have tried the below but even when testing with 90days I am getting no output along with tester it's passing fine, so must be something in my conditions which are not correct.

You'll need to convert the AccountDate to an FME Date (e.g. 20190601), then you can use the DateTimeCalculator to calculate the difference between that and the current date, like so:

Nice question. I covered a similar example in a past webinar. It was checking to see if parking tickets are 6 months past the date of offence.

You can find the webinar here: https://www.safe.com/webinars/deep-dive-fme-desktop-2017/

It includes a link to download the workspaces.

If you'd sooner read about it, rather than watch, I included the same example in a blog post that you can find here: https://www.safe.com/blog/2017/03/fme2017-dates-evangelist162/

I hope this is useful, although @redgeographics is giving you great suggestions anyway. If you are having problems I'd say use transformers (eg the DateTimeCalculator) instead of the function, because it's easier to break down into steps that way, and easier to inspect the result of each step too.

Thanks, Mark, I will have a look at this.

I managed to have a play with it, took me a little longer but I managed to get the results I was after.

Nice question. I covered a similar example in a past webinar. It was checking to see if parking tickets are 6 months past the date of offence.

You can find the webinar here: https://www.safe.com/webinars/deep-dive-fme-desktop-2017/

It includes a link to download the workspaces.

If you'd sooner read about it, rather than watch, I included the same example in a blog post that you can find here: https://www.safe.com/blog/2017/03/fme2017-dates-evangelist162/

I hope this is useful, although @redgeographics is giving you great suggestions anyway. If you are having problems I'd say use transformers (eg the DateTimeCalculator) instead of the function, because it's easier to break down into steps that way, and easier to inspect the result of each step too.