Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to convert the following format:
Date : Sep 2017 to 08-2017
Any suggestions please?
Regards
maybe you have to ltrim some spaces
Excellent Bhargav, your left trim with Youssef's Code worked.
Thanks so much.
Hi Rudra,
Can you please mark it as helpful if it answered your question
Regards,
Bhargav
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
Nice one Pradosh, appreciate your suggestion.
Regards
Thank you very much Massimo
Regards