Unable to Compare Date Field with Today’s Date in subflow

[vivek11]

Hi Team,

I am working on a condition in Flow Designer / Workflow Studio where I need to compare an Employment Start Date field with today’s date.

Example condition:

Employment Start Date before Today

I tried using Data Pills as well but could not find a proper option for current date/time in this context.

Could someone please suggest the best way to achieve this comparison in Flow Designer/Subflow conditions?

Attached screenshot for reference.

Thanks in advance!

PFA

[Ankur Bawiskar]

@vivek11 

so is that date field not available on the table you are using in Lookup record?

Lookup record is on which table?

that date field is on which table?

share some more screenshots

[Tanushree Maiti]

Hi @vivek11 

Refer: KB0830681 Resolving date/time comparison errors in Flow Designer 

Check this as well: https://www.youtube.com/watch?v=jKO_VkLIZ6Q

[Venky Kshatriy2]

Hi @vivek11 

Please create a single flow variable. After setting the flow variable, write a script today and use this variable for your condition.

To set the flow variable, use the following script:

return new GlideDate(); 

If this response addressed your question, please mark it as Helpful and accept it as the solution.