Hebrew dates

[web_time]

Is there an easy way to build a two-column table with standard dates in one column and Hebrew dates in the other? And then for each year, have it automatically update - so I don't have to re-type them all again?

 

[Arvin Meyer]

Is there an easy way to build a two-column table with standard dates in

one column and Hebrew dates in the other? And then for each year, have it
automatically update - so I don't have to re-type them all again?

Since the 2 calendars are different, wouldn't it be different every year?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[web_time]

Yes, they will be different each year. So I need to say that Jan 1 = XYX 12. And then it will convert Jan 2 = XYZ 13, etc. That way I will only need to enter Jan 1 (each year), and the remainder is automatic

 

[John Vinson]

Is there an easy way to build a two-column table with standard dates in one column and Hebrew dates in the other? And then for each year, have it automatically update - so I don't have to re-type them all again?

I've seen a posting here the past month or so from someone using a
custom .DLL which programmatically converts the date. Given the
incommensurability of lunar and solar time, I'd suggest that the best
bet would be a big table with Gregorian and Hebrew dates for the next
century or so (or covering the date range of interest). A hundred
years would only be 36525 rows, a pretty small table in database
terms.

 

[web_time]

Thanks,

Now all I have to do is find it........