Date Expression

[#1]

Hi Can anyone please help, I am stuck.

I have data in my ecxel file of things that happen today, but I only want  a button to return data of things that happen starting from 06:00 AM until now. using this date format: 2012/03/09 8:15:19 AM

Thanks in advance

[jvitantonio]

Here you go

[CELAMBARASAN]

Hi,

     Try with this expression.

     Sum(DateField={">=$(=TimeStamp(Floor(Today())+Time#('06:00','hh:mm')))<=$(=Now())"} Sales)

Hope it helps

Celambarasan

[perumal_41]

Hi,

use this Scirpt for helpful for u

Load * From

Excelfile  where Datefiled >='2012/03/09 6:00:00 AM'

Regards

Perumal A

[#5]

Thanks guys for your replies, I have not been able to find the solution yet, please find the test model I created, in the mean time the button can return all the tings that happen today, but im not able to figure out how to get the things that happen from 6:00 until now.

Regards

Edzi

[perumal_41]

Hi

Please Chech This Application is correct or Not

Regards

Perumal

[#7]

Hi Perumal

It works when you right the expression on the table, but I cant get it working using a button.

Regards

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

[perumal_41]

Hi

I attached Application and This Application U Reload . u Get Result

[#9]

Thanks man, I got it now.

If I may ask again using the same code, how can I get the data that happen a week back from today and a month back from today?

Regards

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

[#10]

Hi ,

I was trying using the button , but I didn't get the solution. Instead I found the alternative solution for you using the straight table which gives the today's date from 6:00 AM to till now. File is attached.

Hope it will help you.

Do let me know if any concern.

Reards,

Kush