Date and time field

[former_member1107312]

Hello,

I have a field that is Date and Time here: {VENSCRAPCOST.TransactionDate}

I have a report made that prompt for the date and time.  What I need to have it automatically uses today date and time from 6:35am and until 2:25pm. The time is at 12hr format here.

Also need to the format for the beginning time from previous date and time: 10:35pm until today date and time: 6:35am.

I would like to use this in formula field.

Any help would be appreciated.

Thank you,
Gerald

[abhilash_kumar · Accepted solution]

Hi Gerald,

So you want the report to return data from:

Previous Day: 10:35 PM to Today: 6:35 AM?

-Abhilash

[former_member1107312 · Accepted solution]

Yes that is exactly what I would like to have.

Thank you,

[abhilash_kumar · Accepted solution]

Hi Gerald,

Go to the Report Menu > Selection Formulas > Record and use this code:

{VENSCRAPCOST.TransactionDate} IN DateAdd('n',1355,DateAdd('d',-1,today)) TO DateAdd('n',395,DateAdd('d',0,today))

-Abhilash

[former_member1107312 · Accepted solution]

Hello Abhilash,

That worked perfectly.

Can you explain to me what 1355 and 395 mean?  I have more times to configure for another report and I would like to know how these times are converted.

Thank you,
Gerald

[abhilash_kumar · Accepted solution]

The 1355 is the time elapsed in minutes since midnight 12:00:00 AM - which is 10:35 AM.

-Abhilash

[former_member1107312 · Accepted solution]

Perfect.  Thank you so much!