Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I need to convert the date format on the following date field.
Trim(Replace([lst pym dt],'.','')) as [lst pym dt]
The result of this is 01042014
I need my result to be 20140401
further on in my script I need to be able to multiply the Year, by 100
if(Year(Trim(Replace([lst pym dt],'.','')))* 100 +Month(Trim(Replace([lst pym dt],'.',''))= '201401',[Payment],0)
Thank you.
Hi
Try this:
Date(Date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYYYMMDD')
HTH
Sushil
Hi ,
try like this:
Date(expression, 'YYYYMMDD')
Hi
Try this:
Date(Date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYYYMMDD')
HTH
Sushil
Hi,
Try this.
date(date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYMMDD') as [lst pym dt]
Regards
ASHFAQ
try
Date(Date#([lst pym dt],'MM-DD-YYYY'),'YYYY-MM-DD')
Date(Date#(Trim(Replace([lst pym dt],'.','')) ,'DDMMYYYY'),'YYYYMMDD') as [lst pym dt]