Problemas with function Format()


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?action=getinfo&userid=25095
View this thread: http://www.excelforum.com/showthread.php?threadid=386378

.

Relevant Pages

  • Re: Fehler im Java melden?
    ... A date in a formated pattern will be convert in to a new date format. ... @param source_picture ... @return the date formated to target_picture */ public static String convertDate(final String date, final String sourcePicture, ...
    (de.comp.lang.java)
  • Re: Problems with .Refresh BackgroundQuery:=False
    ... 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 ... How can I include my param "Dia" in the appropiate format???. ...
    (microsoft.public.excel.programming)
  • Re: Parsing text into dates?
    ... "Thomas W" wrote: ... allthough a format may be provided to give ... '''Tries to parse a string as a valid date and/or time. ... @param implyCurrentDate: If True and the date is not given, ...
    (comp.lang.python)
  • Re: big single sql string
    ... which it puts back on the clipboard. ... automatically with a little program to the syntax of a string constant. ... @Param msg is the string to embed into the error message ... Copies a block of memory to the clipboard in a given format ...
    (borland.public.delphi.language.objectpascal)
  • Re: Help with Date and SimpleDateFormat
    ... > being passed a string and converting it into a date, ... > being passed a Calendar object. ... > public void setRequestedDate(Calendar param) { ... If you want to format it then just do: ...
    (comp.lang.java.programmer)