Creating a simple button using Week and Today() question

Tue, 12 Oct 2010 20:26:55 GMT

Simple question, just getting started.

I would like to create a button to assign the current week to the variable TxnWeek.

Below is how I LOAD the data, and the screen shot is how I imagine it to work.

I am having great difficulty in working with dates in this app. Am I doing something painfully simply wrong?

Thanks for your help.

-------------------------

LOAD @1 as Code,
@2 as Symbol,
@3 as Security,
@4 as TxnDate,
Year(@4) as TxnYear,
Month(@4) as TxnMonth,
Week(@4) as TxnWeek,

Tue, 12 Oct 2010 20:36:39 GMT

So, if you work on a problem for an hour, then take 2 minutes to post a question, you will solve the problem within the next 5 minutes.....

=Week(Today(1))

If the formula does not bold itself, it's not working!

topic Creating a simple button using Week and Today() question in QlikView