Loading a timestamp from csv file

[#1]

I am trying to read a timestamp from a csv

blobname, unitblobname. ,blabla,N,Combustion Turbine,09/01/2009 5:00 PM,MV90 Hourly,0.0

I deifned the timestmap format as MM/DD/YYYY h:mm a, but when I run the Load script, the pivot chart I use to display the dates fails to show me values. This chart has calculated dimension base don the timestamp parameter such as year(timestamp), day(timestamp), month(timestamp)

Is there a better way to Load timestamp data from a csv file?

[Miguel_Angel_Baeyens]

Youmay use the timestamp#() function if you didn't do it before. Use

timestamp#(FieldName,'MM/DD/YYYY h:mm')

Hope it helps!

[johnw]

Need to use "tt" for AM/PM, not "a":

timestamp#(FieldName,'MM/DD/YYYY h:mm tt')