Re: converting 3 x number fields to create date field
From: vw (anonymous_at_discussions.microsoft.com)
Date: 08/11/04
- Next message: Tom Ellison: "Re: Flagging price-downs"
- Previous message: Al Guerra: "Re: Semicolon delimited text query help"
- In reply to: Ken Snell: "Re: converting 3 x number fields to create date field"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 20:39:21 -0700
thks Ken, that worked a treat...
>-----Original Message-----
>Here's one way:
>
>Format(DateSerial([Yearfield], [Monthfield],
[Dayfield]), "mm/dd/yy")
>
>--
>
> Ken Snell
><MS ACCESS MVP>
>
>"vw" <anonymous@discussions.microsoft.com> wrote in
message
>news:3d3d01c47f50$489e1f50$a501280a@phx.gbl...
>> Is there a simple solution to converting day, month and
>> year fields presently in a number format, to one date
>> field?
>> I'm assuming I need to get each field to two integers
>> first? EG I have DD field which shows 7, MM field which
>> shows 1, YY field which shows 3 (for 03). Together
would
>> read 1/7/3, instead of 01/07/03 on conversion.
>> Sorry, not much cop with access. Do I need to use the
>> substring command to bring in missing 0's first or is
>> there an easier way?
>> Cheers
>>
>
>
>.
>
- Next message: Tom Ellison: "Re: Flagging price-downs"
- Previous message: Al Guerra: "Re: Semicolon delimited text query help"
- In reply to: Ken Snell: "Re: converting 3 x number fields to create date field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
