Converting date from yyyy/mm/dd to dd/mm/yyyy

[Ole]

:banghead:Hi

I would like to convert the date format (Swedish) yyyy/mm/dd to (Danish) dd/mm/yyyy. And I need it to be done via programming.

The reason is that I need my database to work in both Denmark and Sweden. I will use 2 databases who needs to be synchronised, but we are using different Date and Valuta formats i Denmark and Sweden.

...so I need to convert Valuta from Swedish to Danish as well.
(Swedish: x.xxx,- kr. to Denmark: kr. x.xxx,xx -)

Is it possible, or am I doing it the wrong way?

Br. Ole

 

[AlexHedley]

Why not just use the Format Function to display it the way you need for each db?

http://office.microsoft.com/en-gb/access-help/format-function-HA001228839.aspx

 

[spikepl]

Explain what you want and in what context. Format has nothing to do with the value stored in your db, which is the same irrespective of country. The automatic formatting used to display data and for data input is set by the locale version of Windows.

 

[Rabbie]

Dates in Access are stored as number of days since 31/12/1899 so you just need to change the display format to what you want. No problems with synching your db there.

The different currencies could be a bit more complicated because of varying exchange rates. You need to establish your business rules to ensure you handle this in a consistent way.

 

[Ole]

Thanks everyone

#SPIKEPL
Right now are we using a Swedish db, and we are online from Denmark.
When we are using a Windows with a Danish setup, the db won't accept our date format. We need to work with a Swedish setup, and that's a bit difficult.

My thought was that we could work with 2 db's and then synchronize them instead of working directly in the Swedish db.

#Rabbie

I know that dates are stored the same way, but every time we start the table(s) we get this "Date" fault. I think that Access takes the format from the local Windows standard, without converting the date, so it matches the db standard.


#AlexHedley

It's no problem displaying the Dates or write the Date the right way.
It's Access who present this fault every time we try to open a Table in the db.

---

The exchange values is no problem, because it's only information. So what you put in is what you need to see.
But it needs to presented correctly - also if you want to export a file to Excel with currency.


Maybe I'm in over my head here...