Expression not working

[krishna20]

Hi Friends,

my condition is

  if(Pol Expiry Date> SysDate   Then

E.Premium = G.Premium

                      /

                  (Pol Expiry Date - Pol start Date) 

                * (Pol Expiry Date - SysDate)

Else

E.Premium  = G.Premium

I converted this expression as

=if((TP_POL_TO_Date)>Today(),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* ((TP_POL_TO_Date)-Today()),sum(G.Premium))

my dates are in format DD-MM-YYYY

Here , if condition is not working , its directly taking else condition.

What may the issue can anyone pls help out.

Thanks & Regards

kalyankrishna

[PrashantSangle]

Hi,

Try like this way

=if(Date(TP_POL_TO_Date)>Date(Today(),'DD-MM-YYYY'),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* (Date(TP_POL_TO_Date)-Date(Today(),'DD_MM_YYYY'),sum(G.Premium))

Or

Try like

=if(num(TP_POL_TO_Date)>floor(Today()),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* ((TP_POL_TO_Date)-Today()),sum(G.Premium))

Regards

[tresesco]

Perhaps your date field is being treated as text, use date#() to convert it to proper date and try like:

=if(Date#(TP_POL_TO_Date,'DD-MM-YYYY')>Today(),(.....

[krishna20]

Hi ,

No change in this.

Regards

krishna

[tresesco]

Possibly, your date field format is causing the issue. Try to share a qvw with sample data.