If date is in two weeks, send email automation flow

[Anonymous]

Hi,

How do I get my flow to send an email if a date is approaching in two weeks? This is what I currently have but its not working. Is there an error in the condition or the variable? 

Variable initialized: 

formatDateTime(addDays(utcNow(),14),'yyyy-MM-dd')

Condition: 

Date is Less than or equal to formatDateTime(addDays(utcNow(),14),'yyyy-MM-dd')

Thanks in advance. 

[abm]

Hi  @Anonymous 

Both dates needs to be formatted to yyyy-MM-dd. 

Thanks

[ManishJain]

Hi @Anonymous, 

formatDatetime gives you output in string whereas if you are comparing output of this with actual datetime field it wont work . You need to format your date time field to the same format before putting your logic there.

Thanks

[Anonymous]

Hi @ManishJain and @abm. Thank you for your responses. 

I fixed the formats of the dates. Is the condition correct or should this be changed too? 

[abm]

Hi @Anonymous 

Could you provide an example? The issue for your current condition is checking the date which is todays date always going to be less than 14 days ahead.