IsValidDateTime
4 min
returns a boolean, the value of which is determined by whether a given date/time value is a valid or invalid utc date/time an optional parameter can be included to check if the date/time is in an hours of operation calendar, for example you may want to check if the given date is a working day, and the time is within working hours syntax isvaliddatetime() enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes business rules editing rules yes business rules initialization rules yes business rules read only rules yes business rules required rules yes business rules validation rules yes client expressions no object permissions no services no ldap no mobile no quick actions (except ui quick actions) yes ui quick actions no reports yes search/dashboard without field references no search/dashboard with field references no parameters parameter description utcdatetime date/time that must be in utc the date/time you want to check is valid hopidorname (optional) the name or the id of an hours of operation calendar return value boolean value if the utcdatetime parameter is valid the function returns true, otherwise false if invalid if the hopidorname parameter is included and the date/time is valid for the calendar (the date falls into a date and the working hours in the calendar), then the function returns true, otherwise false if invalid (the date does not fall into a date in the calendar, and/or the time is not within working hours) example $(isvaliddate(2022 05 07 12 24 )) if 2022 05 07 12 24 is a valid utc date/time the returned value is true $(isvaliddate(2022 05 07, "weekday working")) if 2022 05 07 12 24 is a valid utc date/time and this date/time is in an hours of operation calendar named "weekday working", the returned value is true, otherwise false if not in the calendar, or the date/time is not a valid utc date/time
