Page 1 of 1
StringToDate("#date_2nd_month#")
Posted: Fri Oct 31, 2008 5:14 am
by Benny Domeij
I have defined the parameter date_2nd_month the value 2008-07-31 as a string and in a transformer I've created the variable valid_to_villkor as a date with the expression StringToDate("#date_2nd_month#"). Why am I getting the output ***** to that variable?
Posted: Fri Oct 31, 2008 5:18 am
by ArndW
Try it without the double quotes and hashes - i.e.
string to date
Posted: Sat Nov 01, 2008 3:26 am
by prasanna_anbu
I have used
If(LKP_To_TFM_Check_Null.transaction_dt = "") Then 13 else If(Len(LKP_To_TFM_Check_Null.transaction_dt)<11) Then 13 Else If(IsValid("date",StringToDate(LKP_To_TFM_Check_Null.transaction_dt[1,11],"%mmm %dd %yyyy"))) Then 0 Else 13
in this i have get NOV 3 2008 instead NOV 03 2008
or i have get ****** what can i do for this
Posted: Sat Nov 01, 2008 7:45 am
by ArndW
prasanna_anbu - The question you asked has little to do with the thread, so it is best posed in a new thread - and since you have already done that, it won't get answered here.