how to convert days to month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have one report based on a query , where i have to fields , one is
traveldate , the other is returndate. in the query , i calculate the period .
now , suppose the result is more than 29 days , i want the report to show for
example 1 month.

if it is less than 30 days , is will show the number only , e.g.15

how can i do this.
this information is for patients treatment periods. as there are some
patients with long treatment period such as 190 days , this i want it to show
by month , rather than days.
 
hi,
i have one report based on a query , where i have to fields , one is
traveldate , the other is returndate. in the query , i calculate the period .
now , suppose the result is more than 29 days , i want the report to show for
example 1 month.
if it is less than 30 days , is will show the number only , e.g.15
Click to expand...
Months: Days \ 30
RemainingDays: Days Mod 30


mfG
--> stefan <--
 
Back
Top