use MakeTime and MakeDate together

[anuradhaa]

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)

[Anonymous]

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!!

[anuradhaa]

hi I have used "num(date(ReloadTime() ,'YYYY-MM-DD') &'  '& time(MakeTime(6,3),'hh:mm'))" in text object and it shows "-"

[Anonymous]

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')

[Kushal_Chawda]

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')

[jyothish8807]

have you tried my solution?

Regards

KC

[MarcoWedel]

Hi,

one solution could be also:

myDate < Floor(ReloadTime())+'06:30'

hope this helps

regards

Marco