Forums :: Import/Export Tools

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Import/Export Tools

DwZone Forum Index -> Import/Export Tools

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 171 to 180 of 382 (Total: 233)

First | Prev | Next | Last

Subject

Author

Date

Re: csv Import

Victor

13:52 12 Dec 2010

Import Excel File

EnricLizondo

6:41 12 Nov 2010

Re: Import Excel File

EnricLizondo

7:06 12 Nov 2010

Importing custom DATETIME from CSV

Ryan Dunphy

15:51 6 Sep 2010

Re: Importing custom DATETIME from CSV

Ryan Dunphy

16:04 6 Sep 2010

Oh, and I'm also pretty sure I need to adjust the formatting here

private function FormatAsDate(strValue,format)
'D,',none,NULL
strValue = strValue & ""
if strValue <> "" then
if isDate(strValue) then
myDate = cdate(strValue)
strValue = replace(DbFormatDate,"DD",right("0" & day(myDate),2),1,-1,vbtextcompare)
strValue = replace(strValue,"MM",right("0" & month(myDate),2),1,-1,vbtextcompare)
strValue = replace(strValue,"YYYY",year(myDate),1,-1,vbtextcompare)
FormatAsDate = DateDelimChar & strValue & DateDelimChar
else
FormatAsDate = DateNull
end if
else
FormatAsDate = DateNull
end if
end function

I think I'm onto it by adding something like this??

strValue = replace(DBFormatDate,"HH",right("0" & Hour(myDate),2),1,-1,vbtextcompare)