Check Today's Date vs date in database

Need help Database
1

Hello,

How can I have a workflow that can check a “date” field in the database and see if that field is today or past this date?
It also should include the “time” as well.
I’ve tried using the following and none worked.

  • "Date" field in database > Current Date & Time
  • "Date" formatted as date and time is Current Date & Time

PS: I’m trying to use this in order to show a popup.

Does anyone know how to accomplish this?

Thanks!

3 Likes
2

Bump. Still trying to figure out a solution to this.

1 Like
3

Man I love the help some of us receive on here.

2 Likes
4

If I have spent more time moderating someone (or their requests for moderation) than I am likely to spend helping them… then I don’t.

5

Hello Nigel. What do you mean by moderating? I’ve lost something in the translation from across the pond.

6

Forum moderation.

7

hmm, are you saying he needed alot of moderation, so you won’t answer his question?

Not sure, but in any case, i have the same question now and will continue to search for the answer :slight_smile:

1 Like
8

Not sure does this help, but you can take a look on these forum posts.

Samson @ Plugin Developer
Plugin Page
Plugin Forum

9
  • Create a group in a hidden popup of type yes/no and call it “var- is current date greater than field date?” (var stands for “variable”)
  • Set this expression: current date rounded down to date > field date rounded down to date
  • The above should yield a yes or no value to the var
  • This var can now be used in other expressions
10

hey @taylor1 ,

it is a simple fix. you need to compare both dates in a date only format. So your workflow should look something like this:

image
image714×505 24.8 KB

note that I save the date in step 1 of the workflow but you should just replace that with the date saved in your database:

show popup only when
[date your are comparing to today’s date]:formatted as 6/19/22 is current date/time:formatted as 6/9/2022

date-issue

1 Like
11

That was exactly what I meant. 4 years ago.

1 Like
12

Although I am at a loss now as then to understand why a simple > doesn’t suffice.

image
image559×1009 47.8 KB

The adddition of both “:rounded to” and “:equals rounded to” makes date manipulation a little easier now.

13

Yes, thanks everyone! I was having trouble because i thought it was trying to match the exact time of day (which would have made it inaccurate), but apparently formatting it like @hanan1 suggested is what i needed :slight_smile:

2 Likes
14

A fairly recent addition is the “:equals rounded down to” function. Which does much the same thing.

“:equals rounded down to - day ”
“:equals rounded down to - hour ”
“:equals rounded down to - month ”

etc etc

image

1 Like