Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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
Hi Anil,
Thanks for hint , but it's not giving me right output.
Regards,
Amit
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,
Yes this is working!
Thanks a ton