Hi All,
In my jobs i am converting julian format to date format by using below conditions:
DateToString(StringToDate(Left( XXX,8), "%yyyy%mm%dd"), "%yyyy-%mm-%dd")
this code is working fine when my source column 'XXX' is varchar
But it is not working,if my source column is 'integer'.
Can any one suggest me on this.
I wanted to convert integer to date format.
8 is in place of above symbol like ( xxx,8
thanks
Julian to date format
Moderators: chulett, rschirm, roy
Julian to date format
Thanx&Regards
scorpion
scorpion