Date format in RTC

Business Central/NAV Developers Forum
1

Hi,

I want to write the Date as “7th-September-2011” in RTC. How to write like this.

2

Did you try by usung FORMAT function?

3

Try this one.

=FORMAT(FIELDS!fieldname.value,"“dd/MM/yy”);

Write this by right clicking textbox or whatever and go to expression.

try to avoid FIRST in the value of the Textbox.

4

Try this one.

=FORMAT(FIELDS!fieldname.value,“dd/MM/yy”);

Write this by right clicking textbox or whatever and go to expression.

try to avoid FIRST in the value of the Textbox.

5

Hi,

I checked in that but format i am asking is "07th-September-2011", "01st-September-2011", "02nd-September-2011","03rd-September-2011" like this.

After the Date the 2 character want to come in RTC.

6

Hi,

I checked in that but format i am asking is "07th-September-2011", "01st-September-2011", "02nd-September-2011","03rd-September-2011" like this.

After the Date the 2 character want to come in RTC.

7

D := 010110D;

Message(’%1’,FORMAT(D,0,’<Day,2>st--’));

You should check day before only to add st or nd or rd or th etc

8

Hi,

I am asking in RTC format know, so it will work if we given like this ah,

9

Yes, it will work

10

Hi

Thank you, Its working, but its showing as a message, i dont need in message field.

I need in the “Sales Invoice Header”.“Posting Date” - In Posting Date field I want to write that Date.

11

Are you a technical consultant? [:|] [:’(]

12

Hi,

No. Self Learning

13

Hi,

Sorry yesterday you asked me a question are you a technical consultant.?

I am in Starting Stage in a small concern. Thus by this group i am learning through you guyz. Sorry I will learn quickly,

14

By using the Format function you can show the date in reports…

why do you want the format only?

15

Forum is not a training institute and we are not trainers too…[:O]

Contact Senior developer in your office for training

16

Here’s another option. You’ll definitely need to determine the right value of the date appendix (st, nd, rd, th) before you assemble the formatted date. You can make a pretty easy function to do that – pass the date as an argument and return the date appendix as Text2. The function will be just a big case statement, and will return the appendix value that matches the date.

You might say … where DateNo is an int,

evaluate(DateNo,format(testdate,0,’<>’));

Case DateNo of

1,21,31: Appendix := ‘st’;

2,22: Appendix := ‘nd’;

3,23: Appendix := ‘rd’;

else

Appendix := ‘th’;

end;

That pretty much builds your function for determining the appendix. Then …

DateAppendix := GetDateAppendix(TestDate);

FormattedDate :=

Strsubstno(’%1%2%3’,

FORMAT(TestDate, 0,’<>’),

DateAppendix,

FORMAT(TestDate, 0,’--’)

);