A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Date Conversion Solar date to Gregorian



 
 
Thread Tools Display Modes
  #1  
Old January 4th, 2010, 07:32 AM posted to microsoft.public.access.forms
Mohammad Mobin
external usenet poster
 
Posts: 2
Default Date Conversion Solar date to Gregorian

Dear all,

It would be very kind of you guys, if you could help me to set a date
conversion in a textbox.

I have two fields in a form. The first one stores date in Solar type date
(01/01/1388) I want to set such a coding to covert that date to Gregorian
date.

Example:
Today is 14-10-1388 which is 04-Jan-2010.

Thanks a lot.
  #2  
Old January 4th, 2010, 07:56 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Date Conversion Solar date to Gregorian

On Sun, 3 Jan 2010 22:32:01 -0800, Mohammad Mobin wrote:

Dear all,

It would be very kind of you guys, if you could help me to set a date
conversion in a textbox.

I have two fields in a form. The first one stores date in Solar type date
(01/01/1388) I want to set such a coding to covert that date to Gregorian
date.

Example:
Today is 14-10-1388 which is 04-Jan-2010.

Thanks a lot.


I'm not familiar with solar dates: what's the conversion? Does the solar
calendar use the same month names and lengths?

If so you could probably just use

=DateAdd("d", 226896, [Solardate])

as the control source of a textbox to add the difference in days between the
two schemes.

If the year length or month lengths are different you'll have a more complex
problem!

--

John W. Vinson [MVP]
  #3  
Old January 4th, 2010, 07:22 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Date Conversion Solar date to Gregorian

Which Solar date are you refering? that of Star Trek or Chinese?
-- Chinese
http://www.absolutelyfengshui.com/li...year-month.php

-- Star Trek
http://www.ozgrid.com/forum/showthread.php?p=403291

-- Or another
http://articles.adsabs.harvard.edu/c...&clas sic=YES

--
Build a little, test a little.


"Mohammad Mobin" wrote:

Dear all,

It would be very kind of you guys, if you could help me to set a date
conversion in a textbox.

I have two fields in a form. The first one stores date in Solar type date
(01/01/1388) I want to set such a coding to covert that date to Gregorian
date.

Example:
Today is 14-10-1388 which is 04-Jan-2010.

Thanks a lot.

 




Thread 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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.