Subtracting a date/time field from a number to get date/time

[Lifeseeker1019]

Hi there,



I have a formatting problem and was wondering if anybody could help. I figured this might be possible only through VBA.

what I need to do:

Get the admission date/time by subtracting the DisTimeDateTime (formatted in date/time) from the DisRLOS (formatted as numeric).

in the sample file attached, I just want to be able to go....20.9229 minus 13/02/2013 10:00:00 AM to get the admission date/time (formatted in date/time).

The reason I'm doing is because DisRLOS is basically the result of distimedatetime - admtimedatetime. I know discharge date/time, but just need to get the admit date/time from LOS...


Any help is much appreciated.

[pbaldy]

Well,

[DisTimeDateTime]-[DisRLOS]

in a query results in 1/23/2012 11:51:00 AM (US format since that's where I am).

[Lifeseeker1019]

when I ran it, I got 06/12/1787 11:51:00 AM. Is this because of regional time difference? How do you fix this?

[Lifeseeker1019]

oh nvm...i got it backward....thank you

[pbaldy]

No problem, and welcome to the site by the way!