Next Day

[brindlogcool]

Hi,

Is there any Qlikview function equal to NEXT_DAY function in oracle i need to find the first monday of every month after the 5 working days

[SunilChauhan]

use

date(datefield+1)

[brindlogcool]

Hi Sunil,

So you are saying Date function in Qlikview is equal to Next_day function. Can you please provide an example?

[SunilChauhan]

I am not sayaing date function is equal to next day

after adding + 1 it will will equal to next day

ex:

=Date('01-01-2012'+1)  results in n 02-01-2012

hope this helps

[brindlogcool]

Hi Sunil,

I was looking for different solution. NEXT_DAY in oracle will give you the below result.

SELECT TO_CHAR(NEXT_DAY('01-SEP-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL;

It will give the next monday from the given date.

I am looking for the similar function in qlikview.

Thanks

[daveamz · Accepted solution]

Hi,

See weekstart () function.

     Weekstart (01-aug-2012,1) will return 06-aug-2012.

Regards,

David

[brindlogcool]

Thanks David , this is what i was looking for...