date-variables in set analysis

[#1]

Hi there,

I Need to set the current date in the string, but it doesn´t work.

I have a field, named MeassureDate. There are values like '12.01.2014', '13.01.2014', '14.01.2014' and so on.

Temperature contains weathervalues: 5,2,3,4,7,8 and so on. (Values in °C). Hundreds of values a day.
In Script I set the variable vActDate to Today()

now I made a set Analysis-formula:

Max( {1<MeassureDate = {$(#vActDate)}> Temperature)

A TextBox Returns me 14.01.2014 for vActDate, bit the Set Analysis won´´t work. I get only a '-'.

Does anybody know, how to bind the variables functionaly in the Set Analysis-String?

Thanks a lot for your Help!

Marcel

[jvishnuram]

Hi Marcel,

first thing i observer from your expression is ')' closing parentheses is missing, if it is correct so then use Date() function while assigning the variable., like Date(Today()).

[jonathandienst]

Marcel

Try this:

Max( {1<MeassureDate = {"$(=Date(vActDate, 'DD.MM.YYYY'))"}>} Temperature)

HTH

Jonathan

edit: fixed missing closing bracket

[mjm]

Hello Marcel,

From looking at the script you gave, the first ( after Max is actually red. This identifies an error with this bracket. So you should need another closing ) at the end it seems.

[#5]

Sorry, but doesn´t work.

Max({1<MeassureDate = {"$(=Date(vActDate, 'DD.MM.YYYY'))"}>} Temperature)

[#6]

Yes, I copied it from QV. And only here I lost the bracket.
It does not work with the bracket also. 😞

[#7]

Hi,

I tried this, but no success:

In Script:
Set vActDate = Date(Today())

In Object:
Max( {1<MeassureDate = {$(#vActDate)}>} Temperature)

I put it in a Textfielt, with '=' at the beginning. I got a Entry in the TextBox:
Error in set modifier ad hoc element list: ',' or ')' expected.

But where?

I put the file to this Message.

[#8]

Hi Marcel,

Try the below expression:

max({$<MeassureDate ={"=$(vActDate)"}>} Temperature)

Also makesure that the date formats are same when comparing.

Hope it helps!.

Thanks

[#9]

Hi PriyankaSR,

I am getting values​​. But it is the values ​​for the date, which I have selected in the list box "MeassureDate". But I wanted that getting the values ​​for the date value in the variable vActDate be abgezeigt. Now I have set a 1 instead of the $, but it does not work. There is always the valid value from the list box ("MeassureDate" used to indicate Max (Temperature).

Do you have an idea for this?

Thanks.

[kiranmanoharrode]

Dear Marcel,

     Just go to variable overview (Ctrl+Alt+v) and correct variable vActDate

=Date(Today())

Regards,

Kiran Rode

+91 8976977897