how can i pass null value to time field

(0) Share

Report

Posted on by mohammed.mqi

2,050

greeting everyone

in my report i'm trying to pass null value to time field but i get error

here's my code

if(any2real(jmgStampJournalTrans.StartTime)!=0)
                    {
                        caclutedeAbsenceTMP.Shift1From=jmgStampJournalTrans.StartTime;
                    }
                    else
                    {
                        caclutedeAbsenceTMP.Shift1From=null;
                    }

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Mohammed,

You can't pass null values to the time field. Instead, you can add new "NoYes" field Shift1FromIsNotSpecified and mark it as Yes to indicate that it's null. Or you can just put 0 if time can't be 00:00:00.

BR, Sergei

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

The null reference can be used only for reference types, which isn't the case of utcDateTime. Instead, you can use a default value. One of the way how you can get it is calling utcDateTimeNull().

You can learn a bit more details from AX documentation, such as Null Values for Data Types.

Was this reply helpful? Yes No