on 12-22-2008 7:30 AM
Hi
I am using below formula for report heading
"Analysis Data "&"("&{?ef}&"-"&{?et}&")"
The o/p is Analysis Data(1/1/2007 -12/31/2008)
but i want to dispaly like Analysis Data(1-Mar-07 - 12-Dec-08)
How to convert the dates in formula/
Thank you
Hi
Thanks for your response
I used this formula
"Analysis Data"&"(" &DatePart("d",{?ef})&"-"&MonthName(DatePart("m",{?ef}))&"-"&DatePart("yyyy",{?ef})&"-"
&DatePart("d",{?et})&"-"&MonthName(DatePart("m",{?et}))&"-"&DatePart("yyyy",{?et})&")"
so i am getting o/p like
Analysis Data ( 1 . 00 - January - 2 , 007 . 00 - 31 . 00 - December - 2 , 008 . 00 )
but i want Analysis Data ( 1-jan-07 -31-dec-08)
means date should be 1 rather than 1.00
month should be jan rather than january
year shouls be 07 ratherthan 2,007.00
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Thanks, My problem is solved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To get the date in your format use following formula
DatePart("d",CurrentDate)&"-"&MonthName(DatePart("m",CurrentDate))&"-"&DatePart("yyyy",CurrentDate);
--Kuldeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I don't want to show the difference between dates.
i want to attached the dates to report heading.
i want show dates but in different format.
i want to change date format from 1/1/2007 to 1-mar-07.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of conversion function you can use following formula for date diff
Local DateTimeVar d1 := {Customer_Payment.Date1};
Local DateTimeVar d2 := {Customer_Payment.Date2};
DateDiff ("yyyy", d1, d2) ;
let me know if it solves your problem
-- Kuldeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.