Link to home
Start Free TrialLog in
Avatar of RIAS
RIASFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Format$(CtrlValue, QUERY_DATEFORMAT) in vb.net

Hi,
I have function  
Public Const QUERY_DATEFORMAT As String = "dd mmm yyyy"

Format$(CtrlValue, QUERY_DATEFORMAT) in vb6.0 which converts date from 23/03/2007 to
23 Mar 2007 .
How can I acheive the same in vb.net.
If I use the same code it gives me output as  "dd mmm yyyy" rather than 23 Mar 2007

Cheers
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RIAS

ASKER

Hi,
I got this error
Cannot convert to 'Interface IFormatProvider'.

Cheers
Avatar of RIAS

ASKER

Forgot to mention that It is a string to date conversion I want .
I have string 23/07/2007 which neeed to be converted to date in the format dd MMM yyyy
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RIAS

ASKER

Perfect solution...cheers mate..yuor help is appreciated