User Defined Function that allows to validate if a date is a past date

Hi community,

I was wondering how I can define a User Defined Function that allows to validate if a date is a Past date.

Thanks in advance!

2 Likes

Welcome Etu!

To check to see if a date is a past date, you can compare two date objects using the comparison operators <,>,<=,>=,=. What you can do is compare the current date using DATE_FROM_DATETIME(NOW()) to the date object you are wanting to compare against.

Below is how I structured this User Defined Function so that it takes two parameters. A date parameter and a timezone parameter.

IF(
  date < DATE_FROM_DATETIME(NOW(time_zone)),
  TRUE,
  FALSE
)

You can then reference the IS_PAST_DATE#USER_FUNCTION in the studio once you create the User Defined function. Does this help answer your question?

4 Likes

Yes, it definitely answers my question. Thanks Ismaen!

1 Like