Skip to main content
Question

Generating date and time columns

  • February 20, 2020
  • 1 reply
  • 139 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
    Contributor
    Forum|alt.badge.img+18
    • erik_janContributor
    • 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.

    Reply


    Helpful Members This Week

    Community Stats

    31,286
    Posts
    118,660
    Replies
    38,874
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    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.