Hi all,

need to subtract one date from another to show how long a user was logger in
for.

i.e.

<%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus
<%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>

The values in the sql OFF_DATE and ON_DATE fields are stored as

13/06/2006 19:01:28

Can either be done on the ASP page or in the db itself, doesn't matter
which.

Regards
Simon

[ Post a follow-up to this message ]

Take a look at DateDiff()




"Simon Gare" <sg@simongare.com> wrote in message
news:%23K8xiM9kGHA.2304@TK2MSFTNGP02.phx.gbl...
> Hi all,
>
> need to subtract one date from another to show how long a user was logger
> in
> for.
>
> i.e.
>
> <%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus
> <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>
>
> The values in the sql OFF_DATE and ON_DATE fields are stored as
>
> 13/06/2006 19:01:28
>
> Can either be done on the ASP page or in the db itself, doesn't matter
> which.
>
> Regards
> Simon
>
>

[ Post a follow-up to this message ]

http://www.powerasp.com/content/new...eference-19.htm

"Simon Gare" <sg@simongare.com> wrote in message
news:%23K8xiM9kGHA.2304@TK2MSFTNGP02.phx.gbl...
> Hi all,
>
> need to subtract one date from another to show how long a user was logger
> in
> for.
>
> i.e.
>
> <%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus
> <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>
>
> The values in the sql OFF_DATE and ON_DATE fields are stored as
>
> 13/06/2006 19:01:28
>
> Can either be done on the ASP page or in the db itself, doesn't matter
> which.
>
> Regards
> Simon
>
>

[ Post a follow-up to this message ]