Create Month and Year Attribute from Existing Date Attribute

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • July 23, 2018 at 5:46 pm #606 Score: 0
    HEINRICH SARTIN
    Participant

    Hi,

    I have a global temperature dataset (attached) that has a date attribute in the format mm/dd/yy. I would like to create new attributes for month and year. How would I use the Edit Formula function to create these new attributes?

    Link to CODAP dataset: <span style=”background-color: #ffff00; color: #000000; font-family: Montserrat, sans-serif; font-size: 12px;”>https://codap.concord.org/app/#shared=45917</span&gt;

    Thanks,

    Attachments:
    1. GlobalTemperatures.csv
    July 23, 2018 at 6:02 pm #608
    Jonathan Sandoe
    Keymaster

    Create new attributes named, for example ‘month’. Click on the column header for the attribute, then select “Edit Formula…”. For the formula, type “month(dt)”. Apply a similar strategy for year.

    Jonathan

    July 23, 2018 at 6:19 pm #609
    Bill Finzer
    Keymaster

    Hello Heinrich,

    CODAP has a pretty complete set of functions for manipulating dates and times as you can see in the enclosed screenshot.

    Bill

    Attachments:

    1. date_time_functions.png

    August 2, 2018 at 6:04 pm #668
    HEINRICH SARTIN
    Participant

    Thank you Jonathan and Bill!

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.