[RESOLVED] DATE issue....

[intellogo]

language: VB6
database: MS ACCESS 2000
AMERICAN short date format: M/d/yyyy
INDIAN short date format: d/M/yyyy........(intended format)


i have an mdb table with 2 fields: SignIn DATE & TIME in DATE/TIME format

now in vb, u must be knowing that its stored in the US format by default..the date
and i want to convert it into INDIAN format so i am uing the FORMAT( ) ..ok ?
convertions is happenniing fine

so i am using to Date datatype variables : dteID & dteIT for storing the signin date & time from the db...ok
i am also wanting to store the current date & time in two other date datatype variables: dteOD & dteID

i need two different dates and times..
becoz i want to find the difference between them by using the concatenated expression of dteID & dteID and dteOD & dteOD....

and then i am storeing the concatenated value of dteID & dteIT in dteEntryChrono
and then i am storeing the concatenated value of dteOD & dteOT in dtExitChrono

ISSUE:
----------------------------------------------------------------
values in debug mode:
----------------------------------------------------------------

dteID = 10/11/2006

dteIT = 6:03:51 PM

concatenation code line used: dteID & " " & dteIT

dteEntryChrono = dteID & " " & dteIT
|
|_______10/11/2006 6:03:51 PM



dteOD = 17/11/2006

dteOT = 5:24:24 pm

concatenation code line used: dteOD & " " & dteOT

dteExitChrono = dteOD & " " & dteOT
|
|_______11/17/2006 5:24:24 pm.......HOW CHANGE IN FORMAT

----------------------------------------------------------------

how is it possible that "dteExitChrono" is showing 11/17/2006....when the variables dteOD is showing 17/11/2006...????

--
Regards,
Gautam