topic Re: comparing date with current week's date in QlikView

comparing date with current week's date

Tue, 13 Aug 2013 05:14:47 GMT

Hi,

I need to comapre the end date field with the current week's date i.e., i want to display 'Y' if the end date is within the current week else 'N'.could you please let me know how this could be done

Re: comparing date with current week's date

tresB — Tue, 13 Aug 2013 05:18:23 GMT

Several ways are there, you can try:

If(Week(today())=Week(End Date), 'Y','N')

Re: comparing date with current week's date

Tue, 13 Aug 2013 05:31:41 GMT

Thanks