Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I have a field that shows a date in this format: '201625'
This is the year and the week concatenated.
My problem is that I have to extract the month from that field and I don't know how.
All the help in that subject would be apreciated.
Thanks
solved! Date(MakeWeekDate(Left(week,4),Right(week,2)),'YYYYMMM')