Creating a simple button using Week and Today() question

[#1]

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,

[#2 · Accepted solution]

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!