date format conversions

[Anonymous]

Hi All,

I am trying to convert the following format:

Date :  Sep 2017 to 08-2017 

Any suggestions please?

Regards

[maxgro · Accepted solution]

maybe you have to ltrim some spaces

[Anonymous]

Excellent Bhargav, your left trim with Youssef's Code worked.

Thanks so much.

[bhargav_bhat]

Hi Rudra,

Can you please mark it as helpful if it answered your question

Regards,

Bhargav

[pradosh_thakur]

Hi Rudra

its great that you got the answer but you can try this in the future if you are not really sure about the space in dates.

for example

'  SEP 2017'  :- It has some leading space as well as one space between sep and 2017

'SEP    2017  '  :- It has some trailing  space as well as two  spaces between sep and 2017

what i generally do is

date#(purgechar(date_field,' '),date format withoutspace)

for example

DATE(date#(purgechar(date_field,' '),'MMMYYYY'))

Hope you will find this helpful .

regards

Pradosh

[Anonymous]

Nice one Pradosh, appreciate your suggestion.

Regards

[Anonymous]

Thank you very much Massimo

Regards