torgerjl
11-14-2008, 12:33 PM
Can someone tell me how to do a date part for this...
If{CLOSED_PROJECTS.REQUEST_ID} IN [33963,34067...] then
Date(2008, 09, 30)
Else
{CLOSED_PROJECTS.COMPLETION_DATE} <-- this field is in a mm/dd/yyyy format
So would it be:
...
else datepart("mm","yyyy"{CLOSED_PROJECTS.COMPLETION_DATE})
- I need to have a mm/yyyy format.
If{CLOSED_PROJECTS.REQUEST_ID} IN [33963,34067...] then
Date(2008, 09, 30)
Else
{CLOSED_PROJECTS.COMPLETION_DATE} <-- this field is in a mm/dd/yyyy format
So would it be:
...
else datepart("mm","yyyy"{CLOSED_PROJECTS.COMPLETION_DATE})
- I need to have a mm/yyyy format.