|
|
|
|
|
TOTAL MILK PRODUCTION
IN LTRS.
|
|
<%
function modifydateentry(de)
if len(de) < 2 then
de = "0" & de
end if
modifydateentry = de
end function
function formatMyDate(strDate)
xx = split(strDate,"/")
sDay = xx(0)
sMonth = monthname(xx(1))
sYear = xx(2)
formatMyDate = cdate(sMonth & " " & sDay & ", " & sYear)
end function
dprod= DateAdd("h", -13, now())
'response.write now() & dprod
dp = modifydateentry(day(dprod)) & "/" & modifydateentry(month(dprod)) & "/" & year(dprod)
todate = formatMyDate(dp)
response.write "Daily Report as on Date "& dp & " "
' dprod2=formatdateentry(dprod1)
%>
TOTAL MILK SALE
IN LTRS |
|
|
|
|
|
|
<%
str="select sum(proc_total) as prod from milkprocurement where date_entry='"&dp&"' "
set Rs=con.execute(Str)
response.write (rs("prod"))
'response.write ("
" &dprod &"after" & todate &"scond" & dp)
%> |
|
<%
str1="select sum(qty) as sales from district_sales where date_entry='"&dp&"' "
set Rs1=con.execute(Str1)
response.write (rs1("sales"))
%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
Tamil
Nadu Co-operative Milk Producers' Federation Limited.
Aavin Illam, Madhavaram Milk Colony, Chennai - 600 051.
|
|
|
