topic Re: Date Issue in QlikView

Date Issue

rathnam_qv — Tue, 26 Aug 2014 06:55:33 GMT

Hi All,

i have a date field.my requirement is to create two vriables...From and To.

The From variable should contain the dates like: if the current date is >10 then it should show the dates from the start date of the current month to current date otherwise it should show the dates from the start date of prevoius month to current date.

Can anyone help me out!!

Regards,

Smiley.

Re: Date Issue

senpradip007 — Tue, 26 Aug 2014 07:03:12 GMT

Try like:

vFromDate = If(Day(Date)>10, MonthStart(Date), AddMonths(MonthStart(Date), -1))

vToDate = Date

Re: Date Issue

rathnam_qv — Tue, 02 Sep 2014 07:18:49 GMT

Hi Pradip,

thanks for your reply!!

i have data for 2012,2013 and 2014.

and i have two input fields From ,To--->in From field i want to show dates from jul/01/2014 to till date.
how to do that...helpme out!!

Regards,

Smiley.