Format a Date

Format a Date

I've got a custom query report where the date field is output using LONGTODATE({DateField})

The output of this is a date/time in the format 'DD/MM/YYYY HH:MM AM/PM'

Is it possible to format the output as 'DD/MM/YYYY' (i.e. drop the time?)
                New to ADManager Plus?

                  New to ADSelfService Plus?