My input is Jan
Code: Select all
12 1995 12:00:00:000AM
Moderators: chulett, rschirm, roy
Code: Select all
12 1995 12:00:00:000AM
but my input date is not going to have month as jan every timeArndW wrote:This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.
sorry the input is going to be like thisArndW wrote:This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.
Code: Select all
Jan 12 1995 12:00:00:000AM
Aug 29 1995 12:00:00:000AM
Lance,lshort wrote:You could use the code below to determine the month number.
The rest should be a simple matter of concatenation and the StringToDate function.
Put the delimited Month list in the default value for a Stage Variable (svMM). Leave the derivation empty.
svMM(default) = 'Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec'
use this code to get the month number (ie. 01, 02...12) where Month is the string value from your input.
MM =((COUNT(svMM[1,Index(svMM,Month,1)],'|')+1)/100)[3,2]
info_ds wrote:hi ray,
i tried and got the result --> 19950512
any suggestions?