Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks
I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

Read the CSV file. Then filter the features:

All open orders will be the features where the attribute indicating the closing day is null (or zero? or ...?).

To determine all closed orders within the last 90 days calculate the number of days between today (@DateTimeNow()) and the attribute indicating the closing day for the features where this attribute is not null.

Some date conversions may be needed.

Reply


Community Stats

30,162
Posts
114,488
Replies
37,809
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.