>>>>HELP ME WITH DATEVALUE IN UK FORMAT<<<<<<< 
Author Message
 >>>>HELP ME WITH DATEVALUE IN UK FORMAT<<<<<<<

I am creating a program which has meant to compare the current date obtained form
DATE$ with a date entered in text format from a Database.

If the current date is passed the database date then I want to alarm the
user. To do this I thought I would employe the DATEVALUE function. But It appears
that dispite my windows being set up correctly DATEVALUE only returns a value when
the date is in US format. + DATE$ only returns the date in US format, but can be reformatted

I must work in UK date format, Please can anyone help me?

Johnathan Briggs (Scotland)



Mon, 08 Sep 1997 19:41:32 GMT  
 >>>>HELP ME WITH DATEVALUE IN UK FORMAT<<<<<<<

Quote:


>Subject: >>>>HELP ME WITH DATEVALUE IN UK FORMAT<<<<<<<
>Date: 23 Mar 1995 11:41:32 GMT
>I am creating a program which has meant to compare the current date obtained
>form
>DATE$ with a date entered in text format from a Database.
>If the current date is passed the database date then I want to alarm the
>user. To do this I thought I would employe the DATEVALUE function. But It
>appears
>that dispite my windows being set up correctly DATEVALUE only returns a value
>when
>the date is in US format. + DATE$ only returns the date in US format, but can be
>reformatted
>I must work in UK date format, Please can anyone help me?

Hi Johnathan
Use formatf to convert the date to long format and work in that mode.

------------------------------------------------------------------------
Chuck Stuart - Mesquite TX USA  
VBTrace 2.00 is a runtime Procedure Trace/XReference/Debug/Profiler and
much more. Shareware $49.95.
Available from ftp.apexsc.com/pub/cgvb/visitor.
------------------------------------------------------------------------



Mon, 08 Sep 1997 20:01:53 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. <<<<<<<<ComboBox>>>>>>>>>>>>

2. HELP >>>>>>WIN API <<<<<<<<<<

3. help me out please!!!!<<<<<<<<<<<<<<<<<<<<<<<thanks>>>>>>>>>>>>>>>>>>>>>>>>

4. <><><>HELP<><><> PCMCIA Motorola Montana 33.6

5. >>>> WAV file GRAPH <<<<<<<

6. VB5<->RDO2<->ODBC<->ORACLE Procedure Problem

7. <<<Cneck Box>>>

8. <<<Gif Files>>>

9. <<<CD ROM>>>

10. <<<Win32Api.TXT>>>

11. <<<NetWork Drv>>>

12. >>>> HELP:: URGENT<<<<<<

 

 
Powered by phpBB® Forum Software