BEX web designer 7.0, update roll time update with check box?

[Former Member]

guys this is what i am trying to do?

i have few reports on some cubes,

i have created some queries on the cubes,

created a web template and in item i have placed each query with data load time, so i get the last time the data was updated.

now what i want to do is.. if the data was laoaded yesterday, i want the web template to check if it was loaded today or not, if yes then put a check box in the web template that would be clicked? if not then it would be unchcked with the last time loaded.

in the query designer , i only have the time status of the last query updated, the query is suppose to update everyday? but it can also be updated everyday twice, as once in the morning and once in the evening.

so how do i go and create , an if statement that if date 1(yesterday) is not equal to date 2(today), then have the check box in the web template be checked?

can i create a conditon or exception.. any ideas would be helpful i am stuck...

[Former Member]

i start using visual composer.