on 07-22-2008 9:00 AM
Hi expert,
i am using the "Interactive Form"
I want to change the format date from "22.Apr.2008" to "22.APR.2008".
At moment i am using the field "date" with Display Pattern "DD.MMM.YYYY".
Could you help me ?
Regards
Antonella
Hi,
Just write the following script at exit event of your date field:
$.rawValue = Upper(Format("DD.MMM.YYYY", $.rawValue))
Hope it will solve your problem.
Regards,
Vaibhav Tiwari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think it is better to write a logic.Get the month as per your requirement using FM and concatenate the day,year and month separated by .
Thanks,
Phani Diwakar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Type the following in the script:
$.rawValue = Num2Date(Date(), "DD.MMMM.YYYY");
var ind = At($.rawValue, ".");
var day = Left($.rawValue, (ind-1));
var sub = Right($.rawValue,(Len($.rawValue)-ind));
var ind2 = At(sub,".");
var year = Substr(sub,(ind2+1),(Len(sub)-ind2));
ind = ind +1;
var month = Substr(sub,1,(ind2-1));
month = Upper(month);
$.rawValue = Concat(day,".",month,".",year);
Hope this helps!
Regards
Thashin
Edited by: Thoshin Naicker on Jul 31, 2008 9:47 PM
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.