Hi, I have a question, I need to evaluate two dates, one I have already solved, the one I have solved is like this:
I have a date, and I have to validate with a boolean that must receive a data from 3 months to here, if it is more than 3 months, it is already an invalid date, but the part that I have not solved is, that I mark an invalid date from tomorrow.
I have compared it with an or, but it gives me true, I have this code, and it returns a true
if( local!tipoComprobante = "INVOICE", a!localVariables( local!extraeFecha: substitute(right(local!fechaRecibida, 9), " ", "-"), local!mes: rule!months(month:extract(local!extraeFecha, "-")), local!fechaValida: concat(local!mes, "/", left(local!extraeFecha, 2), "/", "20", right(local!extraeFecha, 2)),
if(
local!tipoComprobante = "INVOICE",
a!localVariables(
local!extraeFecha: substitute(right(local!fechaRecibida, 9), " ", "-"),
local!mes: rule!months(month:extract(local!extraeFecha, "-")),
local!fechaValida: concat(local!mes, "/", left(local!extraeFecha, 2), "/", "20", right(local!extraeFecha, 2)),
or( today() <= edate(local!fechaValida,3), today()+1>local!fechaValida) ), false )
or(
today() <= edate(local!fechaValida,3),
today()+1>local!fechaValida)
),
false
)
this code block is inside an if, could I get some suggestions?
my local variable receives a date with this DD/MM/YYYY format.
Thanks!
Discussion posts and replies are publicly visible