Formatering af tal til dato

tal til en dato?
0402 er IKKE en dato!

but you can use
Right("200402", 4)
to giv eyou another number :o)

actually it will giv eyou a string becaus eif you convert it to a number then you will get 402

jo, det er det, det er det fjerde år i det andet årtusinde, 02 er den anden måned i året.
Sofar I'm using this to "convert" (doesn't have to be a date in "machinelanguage", just want it formatted as 0402)
Right((rst!periode), 4)
This also returns 0402 just fine, except, when I transfer it to Excel, via VBA, it gets "changed" into 402 (the 0 infront dissapears!)

hmmm.....didn't hit "reload" before I started typing, but I see that you've arrived at the same solution as I have......

0402 is NOT a correct date format!
A date format contains a year, month and date and maybe also a time. But a year and months just deosnt go!

If you MUST send this data to Excel then it will have to be as a string!

yes, terry, how do I convert Right((rst!periode), 4)
so I'm sure it's a string?

come on.....terry.....I'm sure you're "up to IT"

I tried using Right(String(rst!periode), 6), 4)
But that didn't work, just got a lotta squares.

Hi puppetmaster!
your comment 22/03-2004 15:01:12 problem is that I too have work to do :o)

Cstr(Right((rst!periode), 4))

should work, but I have no idea how you are putting it into Excel an dit is very likley here it will give problems!