Re: us date format

Bob Wickham wrote in message <43d2b6d9@xxxxxxxxxxxxxxxxx> :

Thanks Roy and Marshall,

That fixed it.
Info for anybody else confused about all this.
This code: (without line breaks)
Me![PaymentDate].DefaultValue = "#" & Format$(Me![PaymentDate], "yyyy-mm-dd") & "#"
will display dates according to the text boxes Format property, as Marshall suggested.
In my case:
dd/mm/yy will display 12/06/05 (12th day of June, 05)
Short Date will display according to your regional settings eg dd/mm/yyyy (12/06/2005) (12th day of June, 2005)

Yes, it works, but, I have read several posts (notably Steve Schapel) suggesting that dates be converted using CLng so as to eliminate any confusion about all the different date formats.
Can anyone explain how I would use CLng with my current problem.

Bob

Number formatting scheme - well, I'm not the best to explain that, since
I don't like using that technique. I'm not sure formatting to long will
work in this scenario, and I'm not sure how it would work against other
databases, for instance SQL server or Oracle ...

I'm happy enough with the knowledge that whenever passing information as
a string - and that's probably the crucial point - as a string - one
need to pass it in an unambiguous format. I will prefer the suggested
format (or use methods that utilize the parameters collection of the
method one uses to execute queries;-)).

--
Roy-Vidar


.

Relevant Pages

  • Re: Tapble top fusion generator
    ... >increased my monitor format to 1280x1024 and display it on a Mitsubishi ... >using a screen format less than 1280x1024 and the low -resolution LCD ... >Since the poster writing about the character overlap, ... is, when you make one web site viewable, you can render others ...
    (sci.physics.fusion)
  • 2 Ques regarding dates (matching and subtracting)
    ... The end-user enters a date in cell a2, validated to format DD/MM/YYYY. ... In K30, I want to display the number of days until the end of the month, ... "Jacob" wrote: ... > I want to use a subtraction or matching formula. ...
    (microsoft.public.excel.misc)
  • Re: us date format
    ... Bob Wickham wrote in message: ... will display dates according to the text boxes Format property, ... Yes, it works, but, I have read several posts suggesting that dates be converted using CLng so as to eliminate any confusion about all the different date formats. ...
    (microsoft.public.access.formscoding)
  • Re: Dividing hours
    ... you can display these in a format that mimics time by making use of the ... The divisional manager will enter in the annual planned hrs on the ... worksheets Each workbook also has a calculation worksheet. ...
    (microsoft.public.excel.misc)
  • Re: Create Dynamic Controls and Displaying Page by Page on the for
    ... My computer is client and other is server. ... I want to display all recevied values for parameters ... > I'm saying this because dynamically creating a few thousand controls might ... >> row data format will be same. ...
    (microsoft.public.dotnet.languages.vc)
Loading