Joined: 06 Jun 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Topic: highlight expert Posted: 15 Dec 2016 at 9:43pm
hi all
I have a report that shows jobs in our system and we have times that the jobs need to be set to. for example:#
'todays date' 13.00. I would like to highlight any jobs where the time doesn't match the 13.00. when I try this because the date is a range of dates then it shows an error.
thanks
kev
Joined: 06 Jun 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Posted: 19 Dec 2016 at 12:12am
hi. no its not to a crosstab
the data is:
scheduled start 10.03 need to be brought to match 10.00 any that don't match 08.00, 10.00 or 13.00 need highlighting so they stand out in the list of times.
hopefully that makes sens.
kev
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 19 Dec 2016 at 3:12am
I think you mean you are having trouble comparing two values that are date time but you only want to compare the time portion of them.
you can use the time() function to strip the date off each.
example for the background color:
if time(table.StandardDateTimeField) <> time(table.UsedDatetimeField) then CrYellow else crNoColor
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
