Compare 2 dates do not work

[ciryaj]

I want to compare duedate and datetoday

dateEnd=string\concatenate(
datetime\year(datetime\today()),"-",
datetime\month(datetime\today()),"-",
subscriptionProfile.billingDueDate,
" 00:00:00");

ifThen(status=="Open",
ifThenElse(datetime\today() < dateEndDate,
status="Overdue",status="Open"));

I am getting the correct dates but it won't compare for some reason it always returns TRUE thus always making it Overdue.

Any help is appreciated.

[ciryaj]

I want to compare duedate and datetoday

dateEnd=string\concatenate(
datetime\year(datetime\today()),"-",
datetime\month(datetime\today()),"-",
subscriptionProfile.billingDueDate,
" 00:00:00");

ifThen(status=="Open",
ifThenElse(datetime\today() < dateEndDate,
status="Overdue",status="Open"));

I am getting the correct dates but it won't compare for some reason it always returns TRUE thus always making it Overdue.

Any help is appreciated.

Fixed it by using different logic

dateEnd=string\concatenate(
datetime\year(datetime\today()),"-",
datetime\month(datetime\today()),"-",
subscriptionProfile.billingDueDate,
" 00:00:00"
);

$diff=datetime\diff(dateEnd,datetime\now());
ifThenElse(
status="Open" && $diff<0,
status="Overdue",status="Open");

[shalmaxb]

Thank you for posting the solution, as you found it. This is how a forum works!