I have the month in the format "Mon" ie August is represented as "Aug". I need to convert the month name to Month Number. The Month function requires a date stamp and I am not able to use the makedate function as it requires month as integer. Can someone help me with getting the month number based on month date?
Isn't it much simpler to temporary change the variable "MontNames".
I work like this.
My normal monthnames format:
Just before the load-script where i need the months shown as numbers i change the var monthnames to:
After the load-script i change it back to its original format.
Please find the attached QVW, which converts the date to your required format.
First I created variable
vDate =Date#(TextBetween(InputDate, ' ', 'th') & '-' & SubField(InputDate, ' ', 3) & '-' & SubField(InputDate, ' ', 4), 'dd-MMMM-yyyy')
then re-used that variable into text box
hope this will solve your problem