Question

Generating date and time columns

  • 20 February 2020
  • 1 reply
  • 5 views
M

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
Rank
Userlevel 2
Badge +16

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.

Reply


Community Stats

28,687
Posts
109,424
Replies
36,543
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.