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"
date format to timestamp
Moderators: chulett, rschirm, roy
Re: date format to timestamp
Here you goharithay wrote: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"
Code: Select all
Oconv(iconv(DSLink3.DATE,"D/MDY[2,2,4]") ,"D-YMD[4,2,2]"):'00:00:00.000'
Kris~