topic Re: How to convert the given date-time format into week start date with day of the week? in QlikView

How to convert the given date-time format into week start date with day of the week?

Tue, 03 Dec 2013 05:14:31 GMT

Friends,

I want to convert the DateTime format into week start date with it's day?. For example:

4/15/2013 9:36:02 AM This need to be converted into (-W-day). Help me to solve this.

If I use weekStart(''4/15/2013 9:36:02 AM') it will return the format like (4/15/2013).

I Need something like 2013-W48-('week start day') OR (W48-Mon) and so on..

Thanks,

Re: How to convert the given date-time format into week start date with day of the week?

jagan — Tue, 03 Dec 2013 05:38:58 GMT

Hi,

Try like this

=Date(Date#('4/15/2013 9:36:02 AM', 'M/D/YYYY h:mm:ss TT'), 'YYYY') & '-W' & Week(Date#('4/15/2013 9:36:02 AM', 'M/D/YYYY h:mm:ss TT')) & '-' & WeekDay(WeekStart(Date#('4/15/2013 9:36:02 AM', 'M/D/YYYY h:mm:ss TT')))

Regards,

Jagan.

Re: How to convert the given date-time format into week start date with day of the week?

tresB — Tue, 03 Dec 2013 05:39:20 GMT

May be like this:

=Year(WeekStart(today()))&'- W'&Week(WeekStart(today()))&'-'&Weekday(WeekStart(today()))

Replace today() with your date.

Re: How to convert the given date-time format into week start date with day of the week?

Tue, 03 Dec 2013 05:53:23 GMT

Hi Tresesco,

Thanks for your replay. And it's working correctly. Another one doubt, Is there any possible to show the actual day instead of the start day?.

Regards,

Thiru

Re: How to convert the given date-time format into week start date with day of the week?

CELAMBARASAN — Tue, 03 Dec 2013 05:54:46 GMT

Try with this

=Replace(WeekName(Today()), '/', '-W') & '-' & WeekDay(WeekStart(Today()))

In the place of Today() you can use Date#('4/15/2013 9:36:02 AM', 'M/D/YYYY h:mm:ss TT').

Re: How to convert the given date-time format into week start date with day of the week?

tresB — Tue, 03 Dec 2013 05:55:33 GMT

Just remove the weekstart() function, it would give you actual day.

Re: How to convert the given date-time format into week start date with day of the week?

Tue, 03 Dec 2013 05:59:29 GMT

Hi Tresesco,

It's working correctly.

Thanks,

Re: How to convert the given date-time format into week start date with day of the week?

Tue, 03 Dec 2013 06:01:08 GMT

Hi Celambarasan,

Thanks,