Dear All…
Please suggest something…
In my client application in view column, I am using @businessday coz i have to calculate diffrence of days… according to date. There is two fields in my form Startdate and Enddate. StartDate field have some validation on button then this field will fill then no problem and Enddate field will fill only on perticular Status(closed Status) according to status. when i am calculation businessday its working fine with Formula ->@BusinessDays(Startdate ;Enddate)…but in view column i have to calulate diffrence if Enddate is not present…means everytime when view will open it will calculate according to @Today if Status is not present.
then i have used this formula -
@if(Status !=“Closed”;@BusinessDays(Startdate ;@Today);@BusinessDays(Startdate ;Enddate))
Then in @today its giving me Error Incorrect data type operator date/time…
I am using @Today Coz in this view i have to show all document(without Closed Status + Closed Status) and claculation is must…
Please please suggest something… what can i do for this…
Thanks in advance