Still getting valid month error?

I have checked it, it also contain NULL value. how to overcome with this problem?

After trying this TO_DATETIME("Candidate UDFs"."Candidate UDF Value 01",'YYYY-MM-DD') and TO_DATETIME("Candidate UDFs"."Candidate UDF Value 01",'yyyy-MM-dd') Still getting the error : Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has…

This is the value in UDF 01.

Still getting the same error. Please help as I need it urgently.

After doing this : TO_DATETIME("Candidate UDFs"."Candidate UDF Value 01",'MM/dd/yyyy') I am getting this error: Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001]…

The UDF column contains format yyyy-mm-dd. Can you give lil demo on this?

I need little help on "Round(DaysBetween(ToDate([Candidate UDF Value 01];"yyyy-MM-dd");CurrentDate()) / 365.25 * 1500;2))". In above formula , Candidate UDF Value 01 is normal column which contains date and in the above calculation I have to calculate days between Candidate UDF Value 01 and Current_Date. I tried CAST and…

Gianni can you give one demo on this little code, how to use CASE statement : If [Candidate UDF Value 06] InList("Part Time"; "Casual"; "Regular Full Time in a Temporary Part Time position"; "Job Share"; "Casual in a Temporary Full Time position"; "Casual in a Temporary Part Time position") Then ToNumber([Candidate UDF…

Thanks Gianni. But this formula contains two then's in one condition like: ElseIf [Candidate UDF Value 02] InList("OPSEU Local 273";"SJHH OPSEU 206") Then (If IsNull([Candidate UDF Value 01]) Then ToNumber([Candidate UDF Value 04]) Else Round(DaysBetween(ToDate([Candidate UDF Value 01];"yyyy-MM-dd");CurrentDate()) / 365.25…