Skip to main content
Question

Generating date and time columns

  • February 20, 2020
  • 1 reply
  • 136 views

Hi there,

I want to create two columns: One column generates the dates between two given dates and second column contains the half an hourly time stamp of each date. For example:

Column AColumn B1/1/202000:001/1/202000:301/1/202001:001/1/202001:301/1/202002:00............................................1/1/202023:302/1/202000:00

 

So that means each date of column A would have 48 values (half an hour slot) of column B. Could you some one tell me how to do that in FME?

1 reply

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • February 20, 2020

That was a fun challenge.

I created this workspace that takes a start date and a number of days and creates the shown output:

The workspace can be found here: Date_Time_intervals.fmw

Hope this helps.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings