Variant data types

[Anonymous]

Hi,

Im getting the error below in the image with my SWITCH statement. Is there a way around this?

I think it might be by using the FORMAT function, but I'm not quite sure where.

Thanks in advance

Liam

[amitchandak · Accepted solution]

@Anonymous 

Use time(18,0,0) in place "18:00:00", so it become time

[Anonymous]

Thankyou @amitchandak