Date creation

qngo · 2006-04-04

I have a report that needs to get the current year, and then get the starting date for the first of that year. I used DATE2DMY(TODAY,3) to get the year, but how do I create a date like 010106D. I would like to make this dynamic instead of having the user enter the date. Any ideas.

Thanks

](*,)

DenSter · 2006-04-04

What about:

DMY2DATE(01,01,DATE2DMY(TODAY,3))

qngo · 2006-04-04

Silly me, I just totally skipped that function detail. Thanks for you help, it works. =D>

DenSter · 2006-04-05

You're welcome, always glad to be of assistance

kine · 2006-04-05

CALCDATE('<-CY>',TODAY)

DenSter · 2006-04-05

I didn't know that. I knew about CY giving you the last day of the year, but the -CY was new to me. Cool

Savatage · 2006-04-05

I needed a terms code to always show June 1st

jm wrote:

Hi Savatage,
try "-CY+5M" (=beginning of current year + 5 Months) .
br
Josef Metz

There are so many different combinations for date calculations that can be used - it needs it's own manual

I'll add this download, so it doesn't get forgotten, in case someone searchs for "Date Creation"
Navision Date Calculator
http://www.mibuso.com/dlinfo.asp?FileID=514

Date creation

Comments

Categories