topic Re: Date Validation in Digital Exchange

Date Validation

rebeccabowe — Wed, 11 Jun 2025 10:53:24 GMT

Hi all,

Can anyone help with this problem - I have 1 Jun 2025 stored in the date item Start Date Text which is read into it via the Read action and when I compare it to the expression below it returns False. However, sometimes when I type the date out myself in the Evaluate Expression it returns True (this has happened twice out of the 15 times I have tried), so I am unsure of the problem

Thanks,

Rebecca

Re: Date Validation

Chakkravarthi_PR — Wed, 11 Jun 2025 11:06:27 GMT

Hi,

This expression does the following:

Today() gets the current date (e.g., 11 Jun 2025).
FormatDate(Today(), "yyyy/MM") converts it to a string like "2025/06".
ToDate(...) converts "2025/06" back to a date, which defaults to 1 Jun 2025.
FormatDate(..., "dd MMM yyyy") formats that date as "01 Jun 2025"

when you add 01 Jun 2025 to Start Date text data item this condition will match. So you have to alter the condition to

FormatDate(ToDate([Start Date]), "dd MMM yyyy") = FormatDate(ToDate(FormatDate(Today(), "yyyy/MM")), "dd MMM yyyy")

Let know if that works.

Re: Date Validation

rebeccabowe — Wed, 11 Jun 2025 11:15:23 GMT

Hi,

Thanks for the fast reply! I seem to be getting this internal error:

Thanks,

Rebecca

Re: Date Validation

Chakkravarthi_PR — Wed, 11 Jun 2025 11:35:34 GMT

What's the "Start Date Text" - Data type.

I have kept it as text and this works fine as below:

If you have the Data type as "Date" change the condition to:

FormatDate([Start Date], "dd MMM yyyy") = FormatDate(ToDate(FormatDate(Today(), "yyyy/MM")), "dd MMM yyyy")