Date format

[kevbrown]

Hi,

I have a spreadsheet which contains a date column. However, some of the dates are formated as dd/mm/yyyy and some are dd.mm.yyyy. Is there a way of formatting all these date as dd/mm/yyyy

Thanks

[#2]

Try like below,

alt(date(date#(DateField,'dd/mm/yyyy'),'DD-MM-YYYY'),date(date#(DateField,'dd.mm.yyyy'),'DD-MM-YYYY')) as Date

[MK_QSL]

Date(Alt(

     Date#(DateField,'DD/MM/YYYY'),

     Date#(DateField,'DD.MM.YYYY')

),'DD/MM/YYYY') as DateField

[PrashantSangle]

Hi,

use MM(capital) instead of mm(lower case)

mm-> denotes minutes

MM-> denotes Month

Kind Regards