web

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

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Finding Current Half y...

Small and medium business | Business Central, N...

Suggested answer

Finding Current Half year from Input Date

(0) Share

Report

Report

Posted on by AliHamza

175

Hi,

'1D+CM' = one day + Current month

'1D+CY' = one day + Current year

'1D+CQ' = one day + Current quarter

How to Find current half year based on above formulas

i.e Current Half year from any input date b/w 01/01/2020 - 30/06/2020 is 30/06/2020

Current Half year from any input date b/w 28/09/2020 - 05/01/2021 is 31/12/2020

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: Finding Current Half year from Input Date

Hi Ali Hamza ,

Can you please try with Calcdate('<6M>',010120D); ?

Thanks.

Was this reply helpful? Yes No
AliHamza 175 on at

Like (0)

Report

RE: Finding Current Half year from Input Date

No, it doesn't work. If Input date is 03042020 then it fails

Was this reply helpful? Yes No
Suggested answer

AliHamza 175 on at

Like (1)

Report

RE: Finding Current Half year from Input Date

Hi Guys,

i found the solution:

if DATE2DMY(InputDate, 2) < 6 then

OutputDate := CALCDATE('-CY+6M-1D', InputDate)

else

OutputDate := CALCDATE('-CY+12M-1D', InputDate)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Rishabh Kanaskar 2,828

#2

Sumit Singh 2,617

#3

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans