Hi all,
I am getting error while converting date formats
here in my job iam converting date to string format and
again iam doing string to date conversion here is my logic
DateToString(a,"%yyyy-%mm-%dd")= b
If IsNull(b) Then SetNull() Else StringToDate(((b)[6, 2]:(b)[9,2]:(b)[1,4]),'%mm-%dd-%yyyy')
while doing this process iam getting warning :
APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost
and in the target dataset its showing data as *******
pls help me out this
Thank you very much
Error while converting date format
Moderators: chulett, rschirm, roy
Error while converting date format
Last edited by kumar3846 on Fri Sep 15, 2006 8:43 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try this
Code: Select all
StringToDate(((b)[6, 2]:(b)[9,2]:(b)[1,4]),'%mm%dd%yyyy')
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'