Comparing Dates on trigger.

[NiceDuck]

Just sharing again.

On triggered action or task, there are certain  cases where you need a condition if the current date is equal to the date value on the field.

However, when you just use compare the date field into a timestamp using the "equal" operator, the results is always false due to "Timestamp" having a time values unlike the one on your current date.

 

 

 

 

 

 

[NiceDuck]

The answer is, use a date diff  day function. kindof like this:





Hope it helps, 

Quack.

[NiceDuck]

You could use this to remove the time values of timestamp via trigger:

 

[Shiro]

@NiceDuck or create a formula field and use this formula instead:

CONVERT(VARCHAR(8),convert(datetime,[@field:EmailSent],101),114)

[NiceDuck]

@Shiro,

As I check, your formula takes the time value and note the date.

You may want to try this instead:

CONVERT(VARCHAR(8),convert(datetime,[@field:Date],101),101)