Converting Date into CYYDDD
In cases where we have to use a Century in the date. Here are some examples below:
- Retrieve Current Date --
- Source: [SystemDate] -- Source Format: 1yyDDD
- Target: Alpha Field -- 113108
- ConvertDate April 18, 2013
- Source: Date Field -- 20130418 --> Source Format: yyyyMMdd
- Target: Alpha Field -- 113108 --> Target Format: 1yyDDD
By: Sean Hoppe on