web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) str2date returns 2011 ...

Microsoft Dynamics AX (Archived)

str2date returns 2011 when passing date 22/06/10

(0) Share

Report

Report

Posted on by Community Member

transdate fromdate ,noholdingfromdate ;

int finOpenYr ;

fromdate=22/06/10

finOpenYr = year(_FromDate); //it returns 2010

noholdingfromdate = str2date('31-MAR' + int2str(finOpenYr),123); but this code returns 31-MAR-2011

Pls help i want it should return noholdingfromdate =31-MAR-2010

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Mohamed Amine HAMDAOUI 540 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can use this code, it works fine in my computer :

noholdingfromdate = str2date(strfmt('31-MAR-%1',finOpenYr),123);

Best regards,

Mohamed Amine

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks it is working

Was this reply helpful? Yes No
Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You can also just use mkDate(31, 3, 2010) function

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans