How to display day from date (from Master data and trans. data)?
I have Master data ID,DATE,YEAR,MONTH,DAY in that I have taken data for ID and DATE(YYYYMMDD) and blank data for YEAR,MONTH,DAY columns and want to display YEAR,MONTH and DAY from the given DATE in the Master data.But there I am geting only YEAR and MONTH but not the DAY.
now i have 2 questions:
1. How to display day as 21 or 24 etc., with the given date.
2. How to display weekday as monday, thuesday, friday etc., with the given date.
3. How to display the above two. if it have taken trans. data
thanks & rerards