Re: Manipulating dates

Look into the Format() function to print any part of a date in almost any
format you might want. The Mid() function can pull a string apart for you.

Denis wrote:
I have a date field in a database. I have been given forms to be
printed out.
The problem is that the form requires the date to be printed out in 3
seperate parts. In the form day month and year.
All numberic with the year in the form of 07 06 05 etc instead of
2007
2006 2005 etc.

Another issue this form has brought is that I have a membership
number
field as an 8 digit string.
The form requires the number to be printed one charachter per box so
I
need to split the string.

Is the above possible and how would I go about it.

Thanks

Denis

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200709/1

.

Relevant Pages

  • Re: Date format detection
    ... Specifies the locale for which the date string is to be formatted. ... date format for this locale. ... the system default-date format for the specified locale. ... be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Code Guidelines
    ... the built-ins can't really be trusted to work with other code. ... Any code that uses String now has that change. ... `Format` as a noun would seem to be a constructor, ... As lengthy as that namespace is, it does not describe string formatting. ...
    (comp.lang.javascript)
  • Re: Date format detection
    ... > Specifies the locale for which the date string is to be formatted. ... > date format for this locale. ... > the system default-date format for the specified locale. ... > be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Date confusion
    ... Read my reply elsewhere in this string. ... > integer portion of the value represents the date as the number of days ... >> If you are working with a numeric date and you want the format DDMMYYYY, ... Another reason for preferring to store a date as text would be personal preference. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regular Expression - old regex module vs. re module
    ... If you want to include backslashes in a string, ... a one character string, which is unlikely to be what you wanted. ... formating characters before a format, then you should use a negative ... #read in and parse a format template ...
    (comp.lang.python)