Question Taking user input while opening Database

[Ratib Hussaini]

Hello everyone, in my database there are fields of type Date/Time, their default value is set to now(). But the problem is that those fields are automatically filled up by English system date. I want my own country's date format, without changing my system date format. So I decided, whenever database is opened it should ask for a date, so the user will give today's date and that date will be used automatically on those fields.

But I dont have any idea how to do it, please help me. Thanks

 

[StarGrabber]

Which is the date format of your country?

 

[jdraw]

See this link for info.
http://allenbrowne.com/ser-36.html

 

[Ratib Hussaini]

in my country Hijri Shamsi is used,, today's date in my country is : 09/19/1391,,,,, and in my system (windows 7) today's date is: 12/09/2012. I checked through internet I found that Hijri shamsi is not supported by Windows 7. Please give your ideas to this problem. Thanks

 

[Ratib Hussaini]

Thnx Mr. Hartman,, I created the code and now its working well.