HOW TO GET YEAR FROM(YYYYMMDD)? HOW TO GET WEEKDAY FROM(YYYYMMDD)
i have 2 questions:
1. I have a date column in my source file like 20071011(yyyymmdd) in this passion. My question is: i want to display only year like 2007</b></b>.
2. One more question is i give the date in 20071011(yyyymmdd) but it should display only the week day like thursday.
please give the step by step procedure for both 1& 2 questions.
thanks & regards,