microsoft query formula for date
 

Hi, im new in this , im doing a query in excel that take info from remedy. i
need to do this everyday and the query must bringe me data from every day .
how can i do it in microsoft query if i put the date i will have to change it
everyday.

in remedy i use $date$ , is any like this?

Thanks in advance

microsoft query formula for date
 

I'm not sure what you are trying to do, but it seems like you might want a
parameter query. See if this website helps:
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/


***********
Regards,
Ron


"ivan" wrote:

Hi, im new in this , im doing a query in excel that take info from remedy. i
need to do this everyday and the query must bringe me data from every day .
how can i do it in microsoft query if i put the date i will have to change it
everyday.

in remedy i use $date$ , is any like this?

Thanks in advance

microsoft query formula for date
 

thanks ron, sorry my english

what im doing is getting data from remedyars<
i need a formula to bring incidents that have been created and still open
from 0 to 24hs
in remedy i have a query like this $DATE$ - 86000
i need this in microsoft query. can you help me?

"Ron Coderre" wrote:

I'm not sure what you are trying to do, but it seems like you might want a
parameter query. See if this website helps:
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/


***********
Regards,
Ron


"ivan" wrote:

Hi, im new in this , im doing a query in excel that take info from remedy. i
need to do this everyday and the query must bringe me data from every day .
how can i do it in microsoft query if i put the date i will have to change it
everyday.

in remedy i use $date$ , is any like this?

Thanks in advance