Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Validation

All good folks! My problem is the following, I looked for everything here and I didn't find something similar. I need to create a custom column that returns me a result if the current date is within ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    = each if [Date] > #date(2021, 12, 20) and [Date] < #date(2021, 12, 24) then 1 else if [Date] < #date(another date) and < #date(another date) then 1 else if [Date] > #date(another date) then 0

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks man i tried it and i got it with this

let
DataAtual = DateTime.Date(DateTime.LocalNow())
in
if [Data Início da Visita] <= DataAtual and
[Data Fim da Visita] >= DataAtual then "Válida"
else "Expirada"