3 Replies Latest reply: Aug 15, 2018 1:07 PM by Todd Buss RSS

    basic date loading syntax

    Todd Buss

      Pardon my noob question.  I've looked through the helpfiles and forum and don't come up with a solution...

       

       

      I'm trying to load dates formatted like this in a CSV file:

      8/15/2018  10:22:00 AM


      Here's the date function I'm using during the load:

      date("DATE & TIME",'M/D/Y  hh:mm:ss tt') as ReportDate,


      I have tried several variations of it, but all I load is nulls.  There's gotta be a simple syntax change to fix this.

       

      Thanks,

      Todd