I ended up building this transform and it works.
Ans = DSDate[6,2]:DSDate[9,2]:DSDate[1,4]
SunTrustDateFormatNew(FedDepr.BEG_DEPR_DATE)
Search found 3 matches
- Tue Mar 25, 2008 11:25 am
- Forum: General
- Topic: Data Conversion
- Replies: 13
- Views: 7351
- Tue Mar 25, 2008 10:53 am
- Forum: General
- Topic: Data Conversion
- Replies: 13
- Views: 7351
Updated Information
I have tried: Oconv(FedDepr.BEG_DEPR_DATE, "MDY[2,2,4]" :@VM:"MCN") which produces: 03/21/1999 I have also tried: Oconv(DateTimeStampToInternal(AsMast.A_DISP_DATE) , "DM[2]"):Oconv(DateTimeStampToInternal(AsMast.A_DISP_DATE) , "DD"):Oconv(DateTimeStampToIntern...
- Tue Mar 25, 2008 9:59 am
- Forum: General
- Topic: Data Conversion
- Replies: 13
- Views: 7351
Data Conversion
How do I take an internal InfoLease system date and convert it to MMDDYYYY without the / showing up? I am getting MM/DD/YYYY.
I have tried individual conversions on the date field with DM[2] DD[2] and DY[4], I have tried "DMDY[2,2,4], and I have tried MDY with no success.
Thanks.
I have tried individual conversions on the date field with DM[2] DD[2] and DY[4], I have tried "DMDY[2,2,4], and I have tried MDY with no success.
Thanks.