PC Review


Reply
Thread Tools Rate Thread

date without /

 
 
=?Utf-8?B?15nXqNeZ15Eg15TXl9eR15nXkQ==?=
Guest
Posts: n/a
 
      27th Dec 2006
hello,
i make string from many fields
i want the date expression will be without the "/"
for exampel 01/01/2006 will be 01012006

can you help me ?
--
תודה רבה
 
Reply With Quote
 
 
 
 
BruceM
Guest
Posts: n/a
 
      27th Dec 2006
In an expression, something like:
Format([DateField],"mmddyyyy")

"???? ?????" <(E-Mail Removed)> wrote in message
news:01B77BF5-F8B6-4243-B903-(E-Mail Removed)...
> hello,
> i make string from many fields
> i want the date expression will be without the "/"
> for exampel 01/01/2006 will be 01012006
>
> can you help me ?
> --
> ???? ???



 
Reply With Quote
 
=?Utf-8?B?V2F5bmUtSS1N?=
Guest
Posts: n/a
 
      27th Dec 2006
Hi
Format the field like this ddmmyyyy

Hope this helps


--
Wayne
Manchester, England.



"יריב החביב" wrote:

> hello,
> i make string from many fields
> i want the date expression will be without the "/"
> for exampel 01/01/2006 will be 01012006
>
> can you help me ?
> --
> תודה רבה

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date? Amanda Microsoft VB .NET 2 10th Oct 2006 06:52 AM
Link date to a table with Date Range (Eff Date and term date) =?Utf-8?B?S2V2aW4gUmVlZA==?= Microsoft Access 1 31st Aug 2006 04:23 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent Mike Saifie Microsoft Access Form Coding 1 9th Mar 2006 01:08 AM
Run Query from date to date, Print the from date to date in the header of the report? Dustin Swartz Microsoft Access Queries 1 25th Jan 2005 07:06 PM
Date fields automatically changing when today date matches date field entry.Help! Brian Cassin Microsoft Access Forms 1 15th Nov 2003 01:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:49 AM.