Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QV12 SR4
I've got some dates in this format:-
Fri Feb 08 2019 14:37:53 GMT+0000 (UTC)
I need just the date portion in this format:-
DD/MM/YYYY
Thought i might be able to do this sort of thing but they all end up blank for some reason?
Date(Date#(SubField(Mid(MyRegDate,4,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],
Any ideas
Just had the wrong number in the Mid statement...
Date(Date#(SubField(Mid(MyRegDate,5,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],
Just had the wrong number in the Mid statement...
Date(Date#(SubField(Mid(MyRegDate,5,Len(MyRegDate)),' G',1),'MMM DD YYYY hh:mm:ss'),'DD/MM/YYYY') as [Reg Date],