Select Week From current date

[#1]

Hi,

i have a question, i have a calendar data contain Date and Week,

For example

Date               Week

01/12/2015          1

01/24/2015          3

Assume today's date is 01/24/2015. So i want to show '3' for the week.

i use this expression, but it doesnt work

=only({<Date={=date(Today(),'MM/dd/yyyy')}>}Week)

really appreciate your help, thanks

[#2 · Accepted solution]

Why don't you try

Week(Today()) as Your expression

[sunny_talwar]

May be this:

=Only({<Date={"$(=Date(Today(),'MM/DD/YYYY'))"}>}Week)

[sasiparupudi1]

try

week(Date#(YourDate,'MM/DD/YYYY'))

[#5]

Wow thanks guys, all of you are true problem solver

thanks

[sasiparupudi1]

You are welcome, glad that you could get the answer you were looking for..

Sas