date converion

[biskra]

in my attached sample i have 2 fields d2 for hijri-date and d1 for DateGreg.
d1 is empty, i want update it evry field with the equivalent date of hijri-date.
any help please.
sorry for my english.

 

[WayneRyan]

b,

Paste this into a new query:

UPDATE t1 SET t1.d1 = [d2]
WHERE (((t1.d1) Is Null));

Wayne

 

[biskra]

thanx for your fast reply.
it give me he same date!
can you apply it on my attached sample.

 

[WayneRyan]

b,

uh-oh!

I thought that if D1 was Null, you wanted it to have D2s value?

Wayne

 

[biskra]

yes but i want d2 with hijri and d1 with gregorein date

 

[WayneRyan]

b,

Oh, I see now!

Does this link help?

http://couprie.docspages.com/calmath/islamic/index.html

Wayne

 

[biskra]

it's a very good link thanx very mutch