Date Conversion Solar date to Gregorian

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.
 
J

John W. Vinson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top