Conditional Show

[#1]

I have a straight table that contains data about patients with upcoming visits.  In the table I only want to show those patients who have an appointment schedule sometime over the next two weeks.

I am trying to use the Conditional Show with the formula

Date(NOV_DATE)<=(Date(TODAY()+14))

but it doesn't seem to be doing anything.  Any suggestions?

[Anonymous · Accepted solution]

Hello,

You add the condicional 'Date(NOV_DATE)<=(Date(TODAY()+14))' in all expressions of the straight table:

if(Date(NOV_DATE)<=(Date(TODAY()+14)), ...expression...)

[#3]

Are u doing in Layout tab of Propertry of Chart?

If yes then u need to know abt that functionality.

it used to Show the Whole object, if condition is true then Show the object else hide the object.

For  ur requirement use below expression in ur expression tab.

Sum(if(Date(NOV_DATE)<=(Date(TODAY()+14)), Sales))

Regrads,

Kabilan K

[#4]

try this

and write date field in the format.

if(date(appont_schedule_date)>=date(today())+14,Patient)

[er_mohit]

try this

make sure date format is same as Date(today()) if not then in script write for NOV_DATE is

date(date#(NOV_DATE,'DD/MM/YYYY'),'DD-MM-YYYY') AS NOV_DATE

IT means the first format is your default format see your Date field Format and replace it with and second one is the format which you desire like Date(today()) format

aggr(only({<NOV_DATE={"<=$(=Date(TODAY()+14)))"}>}NOV_DATE),NOV_DATE)

"}