Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Week number and Months from MM.DD.YYYY

  [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?

1 Solution

Accepted Solutions
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello

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

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

Regards

View solution in original post

4 Replies
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello

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

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

Regards

alexandros17
Partner - Champion III
Partner - Champion III

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

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

sasiparupudi1
Master III
Master III

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;