date format to timestamp

[harithay]

Hi all;



i have input field "DATE" in the format mm/dd/yyyy

output i need "DATE" in the format yyyy-mm-dd 00:00:00.000


i am using following format , but it is giving syntax error(showing red);

Oconv(iconv(DSLink3.DATE,'' D/MDY[2,2,4]") ,"D-YMD[4,2,2]") :" 00:00:00.000"

[ArndW]

You are using 2 single quotes in the first quoted string instead of a double quote.

Use:

Oconv(Iconv(DSLink3.DATE,'D/MDY[2,2,4]'),'D-YMD[4,2,2]') :' 00:00:00.000'

[kris]

Hi all;



i have input field "DATE" in the format mm/dd/yyyy

output i need "DATE" in the format yyyy-mm-dd 00:00:00.000


i am using following format , but it is giving syntax error(showing red);

Oconv(iconv(DSLink3.DATE,'' D/MDY[2,2,4]") ,"D-YMD[4,2,2]") :" 00:00:00.000"

Here you go

Code: Select all

 Oconv(iconv(DSLink3.DATE,"D/MDY[2,2,4]") ,"D-YMD[4,2,2]"):'00:00:00.000'

you typed two single quotes instead double quote...be careful when type

Kris~