problem in date function

[dash]

Hello everyone,

I have two variables for dates i.e. start date and stop date (along with time format) . To skip time, we are using trunc function. when I used the same , I got error like

ERROR: Function TRUNC requires at least 2 argument(s).

Can anyone help me  as I am new.

trunc(stop_date) >trunc(start_date)

when I used datepart function , i got error like

NOTE: Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing value.

[Linlin · Accepted solution]

You should use datepart function. the error message may be caused by missing stop_date or start_date.