Date Function(Current and Future Dates)

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

I have Two fields named Status and Date fields.Those two fields contains the data like

Status

CURRENT

EXPIRED

NONE

Date

10 December 2017

15 February 2018

19 December 2018

11 December 2017

12 December 2017

if Status is None then Date field value should be blank

If Status is current then Date should be current or future date

If Status is expired then Date should be past date

Thanks in advance.

[cweiping]

hi

If date-today is greater than 0 then return 1, equal to 0 is returned, and less than -1.

So 1 represents the future date, 0 represents the current date, and -1 is expired.

If sign (date-today) plus 1 sign again then 1 represents the future and now, and 0 becomes the past date.