0

How would I Filter 'Modified On' (Timestamp) Field to show only records modified today

How would I Filter 'Modified on' (Timestamp) Field to show only records modified today. Iknow this probalbly involves having another field to show true or false but does anyone know the correct formulat to use

 

similar to this 

if Date('Modified on') = today() then
true
else
false
end

 

Regards

Paul

4 replies

null
    • Thunderfix
    • Paul_Kidd_thunderfixco
    • 4 yrs ago
    • Reported - view

    I have managed to solve this issue using the following after a lot of digging around. Maybe it will be of use to someone else using this forum.

     

    if date('Modified on') = today() then

    true

    else

    false

    end

    • Rob
    • 2 yrs ago
    • Reported - view

    Hi Paul, I know this is from a few years back but thanks for posting. Helped me filter my view.

    Much appreciated

    • Bint_Al_Malik
    • 2 yrs ago
    • Reported - view

    Thanks sooooooooooo much Paul

    • Thunderfix
    • Paul_Kidd_thunderfixco
    • 2 yrs ago
    • Reported - view

    Your Welcome

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 1229Views