function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
alex_from_parisalex_from_paris 

Catch error message in calculated field

Hello

I am using datevalue function to transform a string into date

If string is badly formatted; I have an error

I would like to make a test on datevalue function that will calculate today() date if error and datevalue() if not

How can I catch #error! to perform my test ? there is no esterror(datevalue()) function ?

Thanks for your help

Alex

Ispita_NavatarIspita_Navatar

Probably you can try this :-

You must be expecting the string for your date value function in some format say :- 14/10/2010 rite not substitute the characters / at position 3 and 6 with 0 or any number for that matter and then pass the result to the value() function and nest it into the isnumber() function, if it returns true then your date is in correct format.

It will be a complicated formula but will surely work.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
alex_from_parisalex_from_paris

Yes and No

It was a sample with this function

I was wondering how to catch error with this function or other one "which" are waiting for a given type

Thanks for your answer