Ideas

Lava Date Filter for end of date

Note You are not authorized to edit this feature.

0

Login To Vote

Lava Date Filter for end of date

Lava

When working with Lava Date Filters, especially in the context of SQL for a Dynamic Data Block, I haven't found a way to easily 'jump' to the date beginning and ending times. The 'ToMidnight' filter is helpful

It would be helpful to be able to go 'to the end' of the date, similarly to how you can go to 'the beginning' of the date.

My current work around is to take a date, add a day, go 'To Midnight', and then subtract 1 second:

{{ 'Now' | DateAdd:+1,'d' | ToMidnight | DateAdd:-1,'s' }}
Photo of Shawn RossSubmitted by Shawn Ross, Calvary Church (St. Peters, MO)  ·   ·  Lava
Remove Votes
Login to add a comment...

Submission Success Tips

Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.

  • Clear Title: Craft a straightforward and descriptive title that instantly conveys the essence of your idea.
  • Concise Description: Provide an idea description that is succinct, ensuring it effectively communicates the concept without unnecessary verbosity.
  • Provide Additional Details: With a concise description complete, now provide any other details that are needed to better understand the requirements.
  • Thorough Ministry Need Review: Provide a comprehensive overview of the ministry need your idea addresses, emphasizing its significance.
  • Cover the WHY: Clearly articulate the rationale behind your idea, explaining why it's essential and how it aligns with the organization's goals and mission. Oftentimes a clear "why" sheds light into other possible options.