0 votes
1 view
in BI by (17.6k points)

I would think this is relatively straight forward but cant find documentation on how to do it(or the correct syntax to use) and my messing around hasn't worked so far.

For Dates we have a custom format called Month /Day /Year. This pulls back a the date(as a date type) in date format as such:

"14 April 2003"

The code behind this is:

(DATEPART('year', [Close Date])*10000 + DATEPART('month', [Close Date])*100 + DATEPART('day', [Close Date]))

What I want to get back is the month is numeric format like:

"14.04.2003"

Is it simply changing the "month" part in the code to a different type? Has any one come across this? 

Please log in or register to answer this question.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...