Extract the Month from Date

Follow

Mike Spalding

• November 04, 2019 21:46

While cleaning up some superseded nodes, I came across one that is extracting the Month from a Date field.  How is this done in Data3Sixty?  

Mon = month('Original')
emit *, Mon

Do I need to put this in Python and insert it into a Transform node?

 

Thanks

Mike

 

0

• 

  Gerry Mullin

  • November 04, 2019 22:30

  Hey Mike, presuming that the field Original is already of type date you can just do this in a Calculated Fields node. The same would work in a Transform too. Same can be said for extracting year or day values.

  https://www.w3schools.com/python/python_datetime.asp

  

  0

  Comment actions Permalink

Please sign in to leave a comment.