4 Replies Latest reply: Mar 24, 2010 12:41 PM by hngo2000 RSS

    Having problem loading data as DATE format

    hngo2000

      I have tried:

      1) Date([Begin Date]) as EntryDate and

      2) Date(Date#([Begin Date], 'YYYY-MM-DD')) as EntryDate

      but keep getting "null" or "-" as the result. Attached is the original excel data.

      Many thanks.