Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load date which is less than specific date. here in date it has to be in 'YYYY-MM-DD hh:mm' format.
Here date is reload date and hh:mm is MakeTime(6,30).
MakeTime value is dynamic.
so how can i get
mydate < reloaddate in 'YYYY-MM-DD' and Maketime(6,30)
Try to compare into numeric like:
where num(date(Your field,'YYYY-MM-DD hh:mm:ss[.fff] TT'))) <num(date(ReloadTime() ,'YYYY-MM-DD') &' '& time(MakeTime(6,3),'hh:mm'))
Hope this will help!!
hi I have used "num(date(ReloadTime() ,'YYYY-MM-DD') &' '& time(MakeTime(6,3),'hh:mm'))" in text object and it shows "-"
Remove num() as its not working, need to see into it..
You can do like:
=date(ReloadTime(),'DD/MMM/YYYY')&' '&Time(MakeTime(6,30),'hh:mm')
try,
where
timestamp(YourDate,'YYYY-MM-DD hh:mm')<timestamp(date(floor(ReloadTime()) ,'YYYY-MM-DD') + time(MakeTime(6,30),'hh:mm'),'YYYY-MM-DD hh:mm')
have you tried my solution?
Regards
KC
Hi,
one solution could be also:
myDate < Floor(ReloadTime())+'06:30'
hope this helps
regards
Marco