Dear Ahamed,
Perhaps following will help you a lot in this regard:
Date2Str
Syntax str Date2Str (date date,int sequence,int day,int separator1,int
month,int separator2,int year)
Description
Converts the date specified by date to a text string. The sequence of day,
month, and year in the text string is specified by sequence , and the formats
for day, month, and year are specified
by day, month, and year, respectively. The characters that are to be used as
separators in the text string are specified by separator1 (first separator) and
separator2 (second separator).
Examples
In all examples, the variable date contains
the date 23/02/98.
Date2Str(date,123,2,2,2,2,2) returns the text
string "23.02.98". Date2Str(date,321,1,4,4,4,4) returns the text string
"1998/February/23". Date2Str(date,312,2,1,3,1,4) returns the text string
"1988 23 Feb".
Notes
The possible values for sequence are:(day is shown by 1, month by 2, and year
by 3)
: day, month, year
: year, month, day
: year, day, month.
The possible format values for day are:
: day can be expressed as 1 or 2
digits, as required
: day is always expressed as 2 digits.
The possible values for separator1 are:
: a ' ' (space) is used as
separator
: a '.' (point) is used as separator
: a '-' (hyphen) is used
separator
: a '/' (slash) is used as separator.
The possible format values for month are:
: month can be expressed as 1or
2 digits, as required
: month is expressed as 2 digits
: month is
expressed as 3 characters
: month is expressed by its entire name.
The possible values for separator2 are:
: a ' ' (space) is used as
separator
: a '.' (point) is used as separator
: a '-' (hyphen) is used
separator
: a '/' (slash) is used as separator.
The possible format values for year are:
: year is expressed as 2 digits
: year is expressed as 4 digits.
MorphX allocates valid values to the formatting parameters, if the specified
values are not valid.
Tip:
To use the formatting the user has
specified in Regional Settings, use strFmt or date2Str with -1 in all the
formatting parameters. When you let the Regional Settings dictate the format,
be
aware that it can change from user to user, and by such it might not be a
suitable format for external communication.
This help you can also find in the AOT --> Systems documentation --> functions
--> Date2Str (function)
In case you need help, you may feel free to contact.
Regards,
Ashwani Jain
----- Original Message ----
From: Imthiyaz Ahamed <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, 25 January, 2007 12:00:50 PM
Subject: Re: [Axapta-Knowledge-Village] Date to String Conversion
Hi Siva,
Thanks for your Reply. It is vey useful for me, But My requirement is little
bit more. i.e instead of January/23/2007, I wish to print January 23rd, 2007
like this. If it is January/25/2007, it should be January 25th, 2007. Is it
possible by using this function.
If u explain what are the meanings of 213,1,4, it may be very helpful for me.
Once again million of Thanks to u.
Regards,
Imthiyaz Ahamed
----- Original Message ----
From: Siva kumar <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, January 25, 2007 9:15:04 AM
Subject: Re: [Axapta-Knowledge- Village] Date to String Conversion
Hi
you can use the inbuild function Date2Str()
E.g
date2str(today( ),213,1,4, 4,4,4);
It prints January/25/2007
It may help you..
Thanks,
Siva
Imthiyaz Ahamed <imthiyazahamed_ [EMAIL PROTECTED] com> wrote:
Hi Group,
In one of my Report, I wish to display date in string format. For Example If
Date is 24/01/2007, I want it should be January 24th, 2007. What code I need to
write? or any Built-in function is already in Axapta. If so, Please convey that
function or what kind of code I need to write?
Please Advice on this.
Kind Regards,
Imthiyaz Ahamed.A
____________ _________ _________ _________ _________ _________ _
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
http://advision. webevents. yahoo.com/ mailbeta/ features_ spam.html
[Non-text portions of this message have been removed]
We Born to Win...
------------ --------- --------- ---
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
[Non-text portions of this message have been removed]
____________ _________ _________ _________ _________ _________ _
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase. yahoo.com/ promo-generic- 14795097
[Non-text portions of this message have been removed]
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}
#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}
#ygrp-vital a:hover{
text-decoration:underline;
}
#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
[Non-text portions of this message have been removed]
