CONVERTING TIMESTAMP TO SHOW WORKSHIFT

[#1]

Good day

I have a field called EDITDATE that is in a timestamp format. I used the following code to give me a field that shows day or nightshift within my table but it does not work. I have changed my format to show hh:mm only but still it recognises the field as the wrong format.

When I view the table it shows 'NIGHT SHIFT' which it should return when the return expression is false.

PLEASE HELP??????

[swuehl · Accepted solution]

Have you tried something like

if( frac(EDITDATE)>= maketime(6) and frac(EDITDATE) <= maketime(18), 'DAY SHIFT', 'NIGHT SHIFT') as SHIFT

[#3]

I have inserted your script and it works fine.....

Thanx a million buddy

Kind regards

Hein.SNJ