FYI the Date and Time are just text fields exported from a time card.
What is the exact contents of that text field?
GetasDate ( "8/1/13" ) returns the date 8/1/2013 when I test it.
getastime ( "4:15 PM" ) returns the time 4:15 PM.
So I have to wonder what additional text might be present in those fields.
Thanks Phil for responding. I"m not sure how to get your results so I'm posting a screen shot to see if this makes sense. The GetasData and GetasTime are both calculations. Maybe they should be something else?
Well date and Time are not text fields, they are calculation fields. I suspect that if you open them up, you'll find that they do not specify text as the result type.
Thanks Phil. I 've got to tell yo that when I first read your reply I was a bit confused and I think it's becuase I have a field called "Date Time" and that is text. And then I have two fields called "Date" and "Time" that split that text into seperate elements as a calculation that resulted in a number. That was throwing it off. When I went in there and changed the resulting calculation to be text the results came out correctly. THANKS SO MUCH!!! You really helped me.
Have you tried importing the first column's data directly into a field of type TimesStamp? Timestamps store both date and time in one field and the data appears correctly formatted for that to work.
If it does then your calculations to access the time and date can be simplified:
GetasDate ( Timestamp ) will return the date in the timestamp field and GetasTime ( Timestamp ) will return the time--which could completely eliminate the need for your first two calculaiton fields.
Wow. Even better!