Converting Date format

[rido1421]

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.

[avinashelite]

Hi ,

try like this:

Date(expression, 'YYYYMMDD')

[sushil353 · Accepted solution]

Hi

Try this:

Date(Date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYYYMMDD')

HTH

Sushil

[ashfaq_haseeb]

Hi,

Try this.

date(date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYMMDD') as [lst pym dt]

Regards

ASHFAQ

[deepakqlikview_123]

try

Date(Date#([lst pym dt],'MM-DD-YYYY'),'YYYY-MM-DD')

[MK_QSL]

Date(Date#(Trim(Replace([lst pym dt],'.','')) ,'DDMMYYYY'),'YYYYMMDD') as [lst pym dt]