Hello experts, Am customizing a new report,in that how to get no of days between two days? And below is the screenshot of the two dates: This is the field I tried to get : [Field: MCIAvgsales] Use : number Field Set As :#MCISaleFisrtsale - #Lastsalesada Border : Thin Right
You put up your query but it is silent on what the ISSUE is ?? error is ? If in above both your date field are using : UNI DATE Field - then your syntax is correct and should work. also in your field --- Set Always : yes
Gud eve sir, In the above screenshot,in avg sales duration field how to get no of days between the first sale date and last sale date sir....
Set Always : Yes Also since the Field is a Number Field there is no need to invoke the $$Number function.
[Field: MCIAvgsales] Use : number Field Set As : (#Lastsalesada-#MCISaleFisrtsale)/$$NumItemsurchaseLastDate Set Always:Yes Border : Thin Right Width:22 mms Align:Center Format:"decimals:0" made it sir...thankyou very much...for that field I was trying the code and changing the setas,and searching in this forum for nearly 5 hours......and finally its a "set always:yes" which struggeled me... thank you once again sir.....still two fields pending,letme work on those....