Month name from a date

wolverine · 2005-12-22

Hi,

Is it possible in navision to retreive the month name from a date.
For instance, I have the date 22/12/2005, I would like to copy 'december' in a variable.

Thanks.

Marije_Brummel · 2005-12-22

You can use the format function for this.

Marije_Brummel · 2005-12-22

Date
Format
Example

<Closing><Day,2>-<Month,2>-<Year>
0
05-04-03

<Closing><Day,2>-<Month,2>-<Year>
1
05-04-03

<Day,2><Month,2><Year><Closing>D
2
050403D

<Closing><Year>-<Month,2>-<Day,2>
3
03-04-05

<Closing><Day>. <Month Text> <Year4>
4
5. April 2003

<Closing><Day,2><Month,2><Year>
5
050403

<Closing><Year><Month,2><Day,2>
6
030405

<Day,2><Filler Character, >. <Month Text,3> <Year4>
7
5. Apr 2003

The following table below shows how these formats will change if the Regional and Language Options is set to "United States."

US Date
Format
Example

<Closing><Month,2>/<Day,2>/<Year>
0
04/05/03

<Closing><Month,2>/<Day,2>/<Year>
1
04/05/03

<Month,2><Day,2><Year><Closing>D
2
040503D

<Closing><Year>/<Month,2>/<Day,2>
3
03/04/05

<Month Text> <Closing><Day>, <Year4>
4
April 5, 2003

<Closing><Month,2><Day,2><Year>
5
040503

<Closing><Year><Month,2><Day,2>
6
030504

kine · 2005-12-22

Mark wanted to say:

  MonthName := FORMAT(Date,0,'<Month Text>');

is the solution... ;-)

Marije_Brummel · 2005-12-22

Thanks Kamil.

Guess I should have taken more time for this post. :oops:

But somtimes it is more educational to puzzle your way out... O:)

Luc_VanDyck · 2005-12-22

kine wrote:

Mark wanted to say:
[...]

Now we know how he gets that high number of postings:

1. He writes a message giving just a hint
2. He writes a message giving an extract from the on-line help
3. He writes a message giving you the solution

So he writes 3 messages, instead of 1

kine · 2005-12-22

Yes, and I post only posts about previous posts but only in simplier way... ;-)

Marije_Brummel · 2005-12-22

And a smiley post to finish it off...

=D>

DenSter · 2005-12-22

Luc Van Dyck wrote:

Now we know how he gets that high number of postings

=D> =D> =D> =D>

wolverine · 2005-12-23

Thanks. It works.

Merry Xmas. 8)

wolverine · 2005-12-23

kine wrote:
Mark wanted to say:
  MonthName := FORMAT(Date,0,'<Month Text>');
is the solution... ;-)

That was in the help, I should read it carefully next time... :oops:

Thx anyway... :!:

kriki · 2005-12-23

wolverine wrote:

Hi,

Is it possible in navision to retreive the month name from a date.
For instance, I have the date 22/12/2005, I would like to copy 'december' in a variable.

Thanks.

Another possibility is to use the Date-virtual table
recDate of recpord-type Date

recDate.RESET;
recDate.SETCURRENTKEY("Period Type","Period Start");
recDate.SETRANGE("Period Type",recDate."Period Type"::Month);
recDate.SETRANGE("Period Start",datMydate - 50,datMyDate);
recDate.FIND('+');
MESSAGE('%1',recDate."Period Name");

Shenpen · 2005-12-28

kriki wrote:

Another possibility is to use the Date-virtual table

Yeah, sure, and there is another possibility to write an OCX in assembly language that queries data from the observatory in Greenwich over the internet and guesses the current month from the status of the stars, and I am sure there are whole lot of other possibilities but isn't it simpler to just use FORMAT?

Date table is basically for matrix forms of the usual 1/7/31/12 etc. buttons, not very handy for determining current date and such...

Marije_Brummel · 2005-12-28

Could you please post an example of that OCX O:)

kriki · 2006-01-02

Shenpen wrote:

Date table is basically for matrix forms of the usual 1/7/31/12 etc. buttons, not very handy for determining current date and such...

Yes but it can also be used like this, and actually I do use it like this because after all these years with Navision, I still haven't understood the FORMAT-parameters. :oops:
And I am not trying anymore since a few years, because I created my own functions to format numbers and dates with a format that is a lot easier to understand.

BTW : I would also like to see an example of that OCX =P~

rspmca · 2014-11-24

Hi,

I have done this for date name by creating the codeunit.

Name DataType Subtype Length
DateTable Record Date
InpDate Date

InpDate := TODAY;

DateTable.GET(DateTable."Period Type"::Date,InpDate);
MESSAGE(DateTable."Period Name");

and change like this for your requirement...

Thanks,
Rajasekar

Howdy, Stranger!

Quick Links

Categories

Month name from a date

Comments