Formatting a parameter

Hi,

I use the following expression in a parameter =DateAdd("d",-1,Today()) which give me yesterdays date, howver I do need the date to be displayed as dd/MM/yyyy. Is this possible to build into the expression?

Same applies to the =Today() parameter.

July 31st, 2015 10:20am

Try:

=Format(DateAdd("d",-1,Today()) ,"dd/MM/yyyy")

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 10:48am

Thanks just need this =Today() to show in the same format is possible?
July 31st, 2015 10:54am

=Format(Today() ,"dd/MM/yyyy")
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 10:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics