Week.Year format - Qlik Community

Report Inappropriate Content · ‎2014-09-30

hi All,

How we can find weeknumber.YYYY from this date format MM/DD/YYY.

tHANKS

amit_saini · ‎2014-09-30

Try this:

week(Date_Field,'MM/DD/YYY') as weeknumber

Thanks,

AS

Report Inappropriate Content · ‎2014-09-30

week(date)

Week number. Returns an integer representing the week when the fraction of expr is interpreted as a date according to the standard number interpretation.

PrashantSangle · ‎2014-09-30

Hi,

Write

Week(Date#(Date_Field,'MM/DD/YYY'))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

amit_saini · ‎2014-09-30

Also try this:

week(Datefield) & ' / ' & year(Datefield) as Week,

and for weekday:

weekday(Datefield) as Weekday

Thanks,
AS

aveeeeeee7en · ‎2014-09-30

Hi

Use this:

week(YourDateField)&'.'&Year(YourDateField) in your Script and after reload use this field in your Front end.

See the Snapshot:

Also, see the Attachment.

Regards

Av7eN