datetimeformat 
Author Message
 datetimeformat

Hi,

How can I change the datetimeformat of date() from mm/dd/yy to yyyy-mm-dd?
eg
08/12/02 -- 2002-08-12

Thanks



Sat, 29 Jan 2005 00:57:17 GMT  
 datetimeformat


Quote:
> Hi,

> How can I change the datetimeformat of date() from mm/dd/yy to yyyy-mm-dd?
> eg
> 08/12/02 -- 2002-08-12

> Thanks

Function ChangeDate(p_dtmDate)
  ChangeDate = Year(p_dtmDate) & "-" & Month(p_dtmDate) & "-" &
Day(p_dtmDate)
End Function

Not sure if it gives a 4-digit year, but that can be fixed if it doesn't :)

Mythran



Sat, 29 Jan 2005 07:00:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. datetimeformat in userform.textbox

2. DateTimeFormat Schema setting

 

 
Powered by phpBB® Forum Software