Hi
am going to convert the data from D/MDY(Time stamp) format to D-YMD date format using below syntax
OConv(IConv(Arg1[1,10],"D/MDY[2,2,4"),"D-YMD[4,2,2]")
But its failed for below dates.
06/1/2010 0:00:00 because its having data part as 8 characters.
any suggestions???
OConv issue
Moderators: chulett, rschirm, roy
OConv issue
D.N .MURTHY
Thanks for respond, am not supposed to use field function for this scenario because
Source
6/1/2010 0:00:00 am getting o/p 2010-6-1 but i need 2010-06-01, so i used Conversion function to handle this .
its failed for this format (6/1/2010 0:00:00) dates, when i fetch first ten characters its getting 6/1/2010 0
Source
6/1/2010 0:00:00 am getting o/p 2010-6-1 but i need 2010-06-01, so i used Conversion function to handle this .
its failed for this format (6/1/2010 0:00:00) dates, when i fetch first ten characters its getting 6/1/2010 0
D.N .MURTHY
As craig suggested, use something like the below assuming your data is the first field in the space delimited string and there are no leading spaces
Code: Select all
Oconv(Iconv(Field(myDate,' ',1), "D/MDY"), "D-YMD[4,2,2]")