hamideh13935
New Member
- Joined
- Mar 10, 2008
- Messages
- 15
I have an embedded SQL query inside a Pivot Table in excel it contains a date field which has udDate (smalldatetime) datatype in sql server.
the problem is that excel does not consider this field as a date field. i inserted another filed in SQL as "CAST(Date AS smalldatetime) as date2" but doesn't consider date2 as date as well.
I mean when I wanna filter date or date2 in excel it doesn't show me date filters such as tomorrow,today,yesterday,...
could u help me what is wrong?
the problem is that excel does not consider this field as a date field. i inserted another filed in SQL as "CAST(Date AS smalldatetime) as date2" but doesn't consider date2 as date as well.
I mean when I wanna filter date or date2 in excel it doesn't show me date filters such as tomorrow,today,yesterday,...
could u help me what is wrong?
