Microsoft Dynamics AX (Archived)

How hide UtcDataTimeEdit with DateTime Min 1900-01-01 12:00:00

(0) Share

Report

Posted on by ismaelivan

578

Hello !

How can I hide the value in a grid if the date is minvalue type (1900-01-01)

Currently showing 12:00:00 and I need you to show nothing.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Stefan Hofmaninger 520 on at

Like (1)

Report

Hi,

if your field is from type UtcDateTime the minimum value is '1900-01-01T00:00:00'. Check which value is in stored in the field -> if the value is '1900-01-01T12:00:00' you have found the problem.

You can set the value to null by using following method:

utcDateTimeNull()

Regards,

Stefan

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (1)

Report

Hello Stefan, I add the utcdatetime field to the table, and it was inserted with that date by default 1900-01-01 12:00:00. I also create a second column with the name + tzid

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

Hi,

Could you let us know the EDT that you are using on your DateTime field.
As, when I used SysDateTime EDT I am able to get blank value on form and table and

on the backend it stores as "1900-01-01 00:00:00.000".

If it's a custom field you can change its EDT to SysDateTime and check.

Refer screen shot below(Colored in yellow):

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (1)

Report

I do not use any EDT.

I will use sysutcdatetime and I send you my comments.

Thanks!

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (1)

Report

Already use sysutcdatetime but still the time appears, compile and update the table, incremental cyl and restart, but the EDT does not appear in the grid field.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (2)

Report

Hi,

Is the datetime field mandatory on your table? if so I feel it's trying to assign some value. Please try the following code in your data source initvalue method on your form.

Table.DateTime = DateTimeUtil::MinValue();

(or)

Table.DateTime = utcDateTimeNull();

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (1)

Report

Hi Chaitanya, I filled the grid with a button, set a range.

Does not enter the initvalue() method, then insert the line in the method init()

But still showing the time in the column :(

Thanks

Sorry for my English, I'm from Mexico

This show in SQL

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

Hi,

No problem. initValue(on formdatsource) is the method that gets called when a record is created. Please try statement Table.DateTime = utcDateTimeNull() in initvalue (or) in the insert method of the table and also if the datetime is mandatory check by making it optional.

Thanks,

Chaitanya

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (1)

Report

Don't enter in method :(

And I do not think it necessary to put it in the table insert method because the records already exist.

Only from other process, i update the datetime.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

Hi,

initValue method will be called only when we create a record and not during updates.
Please try the same statement i.e Table.DateTime = utcDateTimeNull() when you update the record(s) from other process.

Thanks,
Chaitanya Golla

Was this reply helpful? Yes No