Problemas with function Format()
 

Hi!!!

Thanks for your information but... I've got a doubt about the thing
you've told me.

The macro that I'm using receives the param "Dia" in DATE format bu
I'm not sure if this is the best option or if I should change to strin
format.

My date base accepts the following format: (I was testing this in othe
software)

TO_DATE('29/06/2005 22:59:00','DD/MM/YYYY HH24:MI:SS')

where Dia=29/06/2005 22:59:00

The problem is that I can't use the function TO_DATE in the VBA code
that means I must use the function Format() or not????.

How can I include my param "Dia" in the appropiate format???.

Thank you, thank you and thank you again.

David.


T_BLOC_ARRET.C_BA__DATE_DE_DEB=ADUT """ & Format(Dia,"mm-dd-yy") & ""


Note the changed string part:

""" &
Format(Dia,"mm/dd/yy") & """

The date should be enclosed in quotes, but since youre inside a string
you need to double them. Also you need to convert the date to a string
again for the SQL, so you need to know which string format is accepted
by the SQL source (I assume american date format

--
dmplaceb
-----------------------------------------------------------------------
dmplacebo's Profile: http://www.excelforum.com/member.php...fo&userid=2509
View this thread: http://www.excelforum.com/showthread.php?threadid=38637

Problemas with function Format()
 

Better to stay in the original thread.

--
Regards,
Tom Ogilvy

"dmplacebo" wrote
in message ...

Hi!!!

Thanks for your information but... I've got a doubt about the things
you've told me.

The macro that I'm using receives the param "Dia" in DATE format but
I'm not sure if this is the best option or if I should change to string
format.

My date base accepts the following format: (I was testing this in other
software)

TO_DATE('29/06/2005 22:59:00','DD/MM/YYYY HH24:MI:SS')

where Dia=29/06/2005 22:59:00

The problem is that I can't use the function TO_DATE in the VBA code,
that means I must use the function Format() or not????.

How can I include my param "Dia" in the appropiate format???.

Thank you, thank you and thank you again.

David.


T_BLOC_ARRET.C_BA__DATE_DE_DEB=ADUT """ & Format(Dia,"mm-dd-yy") & """


Note the changed string part:

""" &
Format(Dia,"mm/dd/yy") & """

The date should be enclosed in quotes, but since youre inside a string
you need to double them. Also you need to convert the date to a string
again for the SQL, so you need to know which string format is accepted
by the SQL source (I assume american date format)


--
dmplacebo
------------------------------------------------------------------------
dmplacebo's Profile:
http://www.excelforum.com/member.php...o&userid=25095
View this thread: http://www.excelforum.com/showthread...hreadid=386378