Forum Discussion

Kieranwood's avatar
Kieranwood
Regular Visitor
8 years ago
Solved

Formula help

Hi all,   I'm building a report in which it needs to count 2 columns if certain criteria is being meant which can be seen below.   The basis of the query is if column Hired contains a date and re...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Kieranwood,

     

    You may try the following Boolean expression.

    (try Date.From([Hired]))[HasError] = false
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Kieranwood,

 

You may try the following Boolean expression.

(try Date.From([Hired]))[HasError] = false