9 Replies Latest reply: Apr 1, 2014 5:44 AM by Ashwani Kumar RSS

    Load date/time as date

      I have a csv file I am loading with a date/time field called SessionStarted (e.g. 28/03/2014 08:56).

       

      I need to either load it as a date, or edit my expressions to read the data as a date. Or is it even possible to split the data into two fields when doing the load?

       

      One of my expressions is as follows:

      Count({$<UserName-={"*test*"},Firm-={"Acme"}>}UserName)

       

      Thanks

      Alex