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.  Filter on datetime field that is in string format

    Employee
    Posted 04-17-2015 10:06

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

    Originally posted by: mw9286

    Hello:

    I have a date/time field that is in a string format (10/21/2007 15:57.46). How do I filter on records less than 03/01/2015 00:00:00.

    Thank you


  • 2.  RE: Filter on datetime field that is in string format

    Employee
    Posted 04-17-2015 10:23

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

    Originally posted by: stonysmith

    Lets say that the column name is "myDate"

    d = myDate.left(10).date("MM/DD/CCYY")
emit *
where d < date(2015,3,1)