Week number and Months from MM.DD.YYYY

[sspawar88]

  [created on]

10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
10.01.2015
12.01.2015

My date field is in this format. mm.dd.yyyy

Month( [created on])

week( [created on])

but this is not working.

i'm not getting Month & week field from it.

How can i get 12 months of year and 54 week from this field.

can anyone suggest me?

[julian_rodriguez · Accepted solution]

Hello

Try Month(Date#([created on],'MM.DD.YYYY'))

and Week(Date#([created on],'MM.DD.YYYY'))

Regards

[alexandros17]

the created on field is not recognised as a date field, try something like:

Month( Date#([created on],'MM.DD.YYYY'))

[sasiparupudi1]

Date#([created on],'DD.MM.YYYY') as [created on],

Month(Date#([created on],'DD.MM.YYYY')) as [created on month],

Year(Date#([created on],'DD.MM.YYYY')) as [created on year]

[sunny_talwar]

May be this:

Table:

LOAD *,

          Month([created on]) as [Month Created On],

          Week([created on]) as [Week Created On];

LOAD Date#([created on], 'DD.MM.YYYY') as [created on], //Assuming you date is in DD.MM.YYYY

          OtherFields

FROM source;