Script Logic Help

[amit_saini]

Hi Folks,

I'm using below logic to when I'm having condition based on "Hour".

IF(Hour(Date) < 8, Date-1,Date)  as Date.tmp

Now what I want to do is to have condition based on "Minutes"

I need logic something like below:

IF(Minute(Date) < 08:45:00, Date-1,Date)  as Date.tmp

Please help!

Regards,

AS

[Anil_Babu_Samineni]

Either you could need to elapse time to set as hour to exist like

IF(Minute(Date) < Interval(Interval#(08:45:00,'hh:mm:ss'), 'mm'), Date-1,Date)  as Date.tmp

[amit_saini]

Hi Anil,

Thanks for hint , but it's not giving me right output.

Regards,

Amit

[stabben23 · Accepted solution]

Hi,

I have solved the same problem With this script, maybe need some modification as I use timestampfield and also the other way around. My script is: if time is bigger or Equal than 06 use date else use date-1(yesterday)

if(time(frac(timestamp(Date,'hh:mm:ss')))>=time('06:00:00'),timestamp(Date),timestamp(timestamp(Date)-1)) as %Date,

[amit_saini]

Yes this is working!

Thanks a ton