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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|