Dynamics NAV HOW TO Microsoft

HOW TO calculate the Day of the Year number in C/SIDE

You can calculate the Day of the Year number in C/SIDE by the difference between the date (in my example I use the current date defined by the operating system using the function TODAY) and the first day of year of the date using the CALCDATE function. You need to add 1 to the result to include the day of the date that you are using.

HOW TO calculate the Day of the Year number in C/SIDE

[sourcecode lang=”Cside”]
Number := TODAY-CALCDATE(‘<-CY>’,TODAY)+1;

If you need it as Text you need to convert it using the FORMAT function
[sourcecode lang=”Cside”]

Did my HOW TO help you? Leave a reply.

Chrome Google Internet Explorer Microsoft Mozilla Firefox Tips & Tricks W3C

Tips & Tricks – create sitemap automatically

To create automatically an updated site map (or sitemap) of your website I suggest you to use the

Sitemaps Generator

XML Sitemaps Generator |
Create your Google Sitemap Online – XML Sitemaps Generator


  • Free Online Generator (Maximum 500 pages)
  • Unlimited Generator (No limits)
  • Online PRO Service

To use the online Free Service, you need to enter some simple details:

  1. the full http address for your site
  2. change frequency
  3. last modification (if you don’t know use “Use server’s response”)
  4. priority (if you don’t know use “Automatically Calculated Priority”)

Then Start. Maximum 500 pages will be indexed in sitemap.

With the Free service, after process, you can download the following formats:

  • un-compressed XML (.xml)
  • compressed XML (.xml.gz)
  • HTML (.html)
  • in Text Format (urllist.txt)
  • ROR (ror.xml)

With the Payment Services you can generate any kind of Sitemap you require:

  • XML
  • HTML
  • Images
  • Video
  • News
  • Text formatted
  • Mobile

Do you think that my Tip & Trick is useful? Leave a reply.