current day

[Anonymous]

hi,

i have field with date, i want to show all the line that Greater than today date,

it's obvious that today date should Refers to the current date iche day.

how can write in the script ...

if[(datefield]>Today([datefield),'שולם','צק דחוי') as(status)

thanks'

yarin

[jonathandienst]

Hi

This should do it:

if(datefield > today(), 'שולם' ,'צק דחוי') as status

Regards

Jonathan

Fixed missing closing bracket