Skip to main content
Question

Generating date and time columns

  • February 20, 2020
  • 1 reply
  • 176 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?

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    erik_jan
    Contributor
    Forum|alt.badge.img+22
    • erik_janContributor
    • Contributor
    • 2179 replies
    • 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.

    Community Stats

    32,076
    Posts
    121,800
    Replies
    39,707
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.