In x++ date validation.

(0) Share

Report

Posted on by WaytoAx

130

Hi guys,

i have a two Date fields one is 'Project issuance' another one is 'Project expiry'.

my requirement is a Project duration for 6 month.

Ex :

in Project ID < P001 < Project issuance date<"6/25/2020"> <Project expiry<12/31/2020>

Project ID <P002 < Project issuance date<"6/26/2020"> <Project expiry<01/01/2021>

Now, day by day based on Project ID we need to calculate date how can i write in x++.

i planned to write in OnmodifiedField.

Thanks,

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

So do you want to validate that values that the user enters are ok according to some rule?

Or do you want to automatically calculate Project expiry date when the user enters Project issuance date?

In your question title you were talking about validation.

You should use validateWrite method for most validations. You should NOT use "onModified" event for validations. It's important to put code in correct place to guarantee readability and maintainability of your code.

Could you please try to explain your requirement once more, as clearly as possible? Thanks!

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

Thanks for you quickly replay Nikolaos Mäenpää Sir,

yes! i want calculate Project expiryDate when the user enters Project issuance date correct.

day by day calculate based on today date how can i get in x++ ?

give us a example.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can use DateTimeUtil::addMonths() function to add months to a datetime variable.

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

Why! i'm used a date filed not a dateTime and in the DateTimeUtil::addMonths(passed an utcdateTime , int) what should i do ?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

In general I suggest using DateTime fields instead of Date fields - you can hide the time part.

But you can of course convert your date into date time. And a date time back to date.

www.google.com/search

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

Thanks , even if it datetime field we can't get calculate datetime in this function DateTimeUtil::addMonths() i tried it is not working on it.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I'm sure that the function works. It returns a DateTime with the added months. Did you remember to take the return value and use it?

If you need help with your code, please share it.

Was this reply helpful? Yes No
WaytoAx 130 on at

Like (0)

Report

thanks sir i totally over looked it it is working fine now.

Was this reply helpful? Yes No

Join the conversation

Community site session details

In x++ date validation.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

In x++ date validation.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates