LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Change excel types dates eg 42475 to a date eg 15-Apr-16

    Employee
    Posted 11-29-2012 05:27

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: CPRA

    I have a csv where the date is in the microsoft excel serial number format. It has come into Lavastorm as a string, how do i convert that into a date please?


  • 2.  RE: Change excel types dates eg 42475 to a date eg 15-Apr-16

    Employee
    Posted 11-29-2012 06:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aop

    Hi!

    You could use something like this inside a filter (here EXCELDATEVALUE is the field containing date in excel serial number format formatted as string):

    ConvertedDate=addDate(date(1900,01,00), long(EXCELDATEVALUE)-1, "days")
    emit ConvertedDate


  • 3.  RE: Change excel types dates eg 42475 to a date eg 15-Apr-16

    Employee
    Posted 11-29-2012 07:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: CPRA

    Genius. That works. Thanks!