In one of the activity feeds, I am getting only the date. There is no time present in the file. I have mapped the date to DATETIME and specified the format of the date. When I run the import, it's still giving me the Date/Time missing error. The date is in the form 26-MAR-13. The format I have specified is dd-MMM-yy.

asked 14 Jun '13, 11:18

swadhwa's gravatar image

swadhwa
5116
accept rate: 100%


I figured out the issue. In the regex , I had specified the month as (\w+). Since it's upper case, it did not pick it up. I changed it to [A-Z]+. It matched the case and picked up the month and date perfectly

link

answered 14 Jun '13, 11:59

swadhwa's gravatar image

swadhwa
5116
accept rate: 100%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3

Asked: 14 Jun '13, 11:18

Seen: 1,001 times

Last updated: 14 Jun '13, 11:59