Date Conversion Solar date to Gregorian

  • Thread starter Thread starter Mohammad Mobin
  • Start date Start date
M

Mohammad Mobin

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.
 
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.
Click to expand...

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!
 
Back
Top