Hi All,

I need to check planned orders from whinp100, with transaction date
equal to different dates.
However i dont want to check the time part in utc and want to check only the date part in the transaction date in whinp100.

Any ideas how a query can be written for this?


regards,

Abhijit

Hi,

You can use the utc.to.date (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_utc_to_date) or utc.to.local (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_utc_to_local) functions.

I hope it helps,

- George