Good day to you.
I am doing the BO for fiscal day...
Now I have 4 attribute:
- DayNumber, Say 25
- DayMonth, Say 12
- DayYear, Say 2011
- Date Format as 'dd/mm/yyyy'
How do I convert back to Date Format?
I use AS_DATE(Name.DayNumber, Name.DayMonth, Name.DayYear, 'dd/mm/yyyy') - ERROR?
I use DATE, also ERROR?
so how to convert to date? thanks....
