Sign Up |  Live StatsLive Stats    Articles 39,024| Comments 192,238| Members 20,146, Newest Khalsasingh| Online 342
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags

converting Excel integer date format

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 300 USD, Received: 50 USD (17%)
Please Donate...
       

Tags
converting, excel, integer, date, format
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 07:08 AM
RB Smissaert's Avatar RB Smissaert
Guest
 
Posts: n/a
   
   
converting Excel integer date format

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
I am opening a text file (see thread: automate open text file) that has a
column with the Excel integer date format, the ones like this: 38855.
What is the easiest way to convert this in Access to a date like this:
dd/mm/yyyy?
Thanks for any advice.

RBS



Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9877-converting-excel-integer-date-format.html

*







Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 07:08 AM
bart.smissaert@gmail.com's Avatar bart.smissaert@gmail.com
Guest
 
Posts: n/a
   
   
Re: converting Excel integer date format

Figured this out now. Go into design view, selec the field and put
dd/mm/yyyy in the format edit box.

RBS

Reply With Quote
  #3 (permalink)  
Old 28-Jul-2006, 07:08 AM
bart.smissaert@gmail.com's Avatar bart.smissaert@gmail.com
Guest
 
Posts: n/a
   
   
Re: converting Excel integer date format

  Donate Today!  
Figured this out now. Go into design view, selec the field and put
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9877
dd/mm/yyyy in the format edit box.

RBS

Reply With Quote
   Click Here to Donate Now!
Related Topics...
Thread Thread Starter Forum Replies Last Post
Converting Now() to pure date Domac Information Technology 4 28-Jul-2006 07:24 AM
Date Format Zanstemic Information Technology 5 28-Jul-2006 07:23 AM
Date format Mr Johnson Information Technology 1 28-Jul-2006 07:08 AM
Date format Elaine Information Technology 4 28-Jul-2006 07:01 AM
Converting date format rockocubs Information Technology 5 05-Nov-2005 10:49 AM


Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools
Display Modes

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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Fools Who Wrangle Over...
Today 09:25 AM
1,304 Replies, 154,487 Views
5 K's: Symbolic or...
Today 03:38 AM
2 Replies, 68 Views
Is Sikh Philosophy...
By eileen
Yesterday 23:30 PM
0 Replies, 56 Views
Freshness in mouth while...
Yesterday 22:53 PM
8 Replies, 236 Views
09-11-2014
19-Oct-2014 23:02 PM
4 Replies, 1,643 Views
Waheguru Simran, Nitnem,...
19-Oct-2014 22:55 PM
82 Replies, 8,255 Views
Colour Red Gursikh...
11-Oct-2014 22:22 PM
13 Replies, 469 Views
Akal Takhat Jathedar...
10-Oct-2014 06:51 AM
8 Replies, 334 Views
GGS being burnt
09-Oct-2014 10:38 AM
58 Replies, 1,746 Views
Can we ever see Sri Guru...
09-Oct-2014 06:37 AM
67 Replies, 2,256 Views
Recreated Sikh regiment...
07-Oct-2014 10:54 AM
2 Replies, 307 Views
Deccani Sikhs: Punjabi...
02-Oct-2014 19:38 PM
0 Replies, 255 Views
Can I wear a Dumalla
By Akasha
02-Oct-2014 03:13 AM
12 Replies, 522 Views
Do you wear Kara?
30-Sep-2014 23:01 PM
5 Replies, 3,645 Views
Thought of the Moment!
30-Sep-2014 22:12 PM
320 Replies, 34,821 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +5.5. The time now is 11:55 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright 2004-2015, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.22761 seconds with 34 queries