VB Date Query

jpc1

Hi guys was hoping someone might be able to solve this. I have a date format and I am trying to get it to publish ddmmyyyy but its doing mmddyyyy


fDate = 0
ldate = Year(Now()) & right("0" & Month(Now()),2) & _
right("0" & Day(Now()),2) & _
right("0" & Hour(Now()),2) & _
right("0" & Minute(Now()),2) & _
right("0" & Second(Now()),2)

Function ConvertDate ( pdate )
dim larr
if ( InStr(pdate,"/") > 0 ) then
larr = split(pdate,"/")
ldate = larr(2) & larr(0) & larr(1)
else
ldate = pdate
end if

ConvertDate = ldate
end Function

srsly78

Use the builtin functions instead of rolling your own: http://msdn.microsoft.com/en-us/library/3eaydw6e.aspx