web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) In a ComputedColumn ho...

Microsoft Dynamics AX (Archived)

In a ComputedColumn how I can validate a Date field empty value?

(0) Share

Report

Report

Posted on by ismaelivan

578

I have a computed column, i like validate a date field, if is empty do somethiing...

5657.cc.png

It does not allow me to debug in computedcolumn

Can you help me.

Thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I try to validate duedateStr1, not duedateStr

Was this reply helpful? Yes No
Suggested answer

Srini Ramidi 2 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can use dateNull() to validate if the Date field has value.

if(table.Datefield==dateNull())

{

}

Was this reply helpful? Yes No
Verified answer

ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Thanks, the solution was

dueDays = SysComputedColumn::if("CHARINDEX('1900'," + duedateStr1 + ") = 0",

SysComputedColumn::getDateDiff(duedateStr1,duedateStr,SysComputedColumnDatePart::Day),

SysComputedColumn::getDateDiff(duedateStr2,duedateStr,SysComputedColumnDatePart::Day));

Thank very much!!!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans