GetDateExpression Function

Number of input and output field

Number of input field : One
Number of output field : One or Two

This transformation function is used to extract the date expression from an incoming input string.

The results of this transformation are:
The capturing process is performed using the following regular expressions, evaluated in order of priority:
  1. (?i)(\d\d\d\d)[-/\s]?(Jan.*)[-/\s]?(\d\d)(?-i)
  2. (?i)(\d\d\d\d)[-/\s]?((?:Peb.*)|(?:Feb.*))[-/\s]?(\d\d)(?-i)
  3. (?i)(\d\d\d\d)[-/\s]?((?:Mar.*))[-/\s]?(\d\d)(?-i)
  4. (?i)(\d\d\d\d)[-/\s]?((?:Apr.*))[-/\s]?(\d\d)(?-i)
  5. (?i)(\d\d\d\d)[-/\s]?((?:Mei.*)|(?:May.*))[-/\s]?(\d\d)(?-i)
  6. (?i)(\d\d\d\d)[-/\s]?((?:Jun.*))[-/\s]?(\d\d)(?-i)
  7. (?i)(\d\d\d\d)[-/\s]?((?:Jul.*))[-/\s]?(\d\d)(?-i)
  8. (?i)(\d\d\d\d)[-/\s]?((?:Agu.*)|(?:Ags.*)|(?:Aug.*))[-/\s]?(\d\d)(?-i)
  9. (?i)(\d\d\d\d)[-/\s]?((?:Sep.*))[-/\s]?(\d\d)(?-i)
  10. (?i)(\d\d\d\d)[-/\s]?((?:Okt.*)|(?:Oct.*))[-/\s]?(\d\d)(?-i)
  11. (?i)(\d\d\d\d)[-/\s]?((?:Nop.*)|(?:Nov.*))[-/\s]?(\d\d)(?-i)
  12. (?i)(\d\d\d\d)[-/\s]?((?:Des.*)|(?:Dec.*))[-/\s]?(\d\d)(?-i)
  13. (?i)(\d\d\d\d)[-/\s]?(Jan.*)[-/\s]?(\d(?:\d)?)(?-i)
  14. (?i)(\d\d\d\d)[-/\s]?((?:Peb.*)|(?:Feb.*))[-/\s]?(\d(?:\d)?)(?-i)
  15. (?i)(\d\d\d\d)[-/\s]?((?:Mar.*))[-/\s]?(\d(?:\d)?)(?-i)
  16. (?i)(\d\d\d\d)[-/\s]?((?:Apr.*))[-/\s]?(\d(?:\d)?)(?-i)
  17. (?i)(\d\d\d\d)[-/\s]?((?:Mei.*)|(?:May.*))[-/\s]?(\d(?:\d)?)(?-i)
  18. (?i)(\d\d\d\d)[-/\s]?((?:Jun.*))[-/\s]?(\d(?:\d)?)(?-i)
  19. (?i)(\d\d\d\d)[-/\s]?((?:Jul.*))[-/\s]?(\d(?:\d)?)(?-i)
  20. (?i)(\d\d\d\d)[-/\s]?((?:Agu.*)|(?:Ags.*)|(?:Aug.*))[-/\s]?(\d(?:\d)?)(?-i)
  21. (?i)(\d\d\d\d)[-/\s]?((?:Sep.*))[-/\s]?(\d(?:\d)?)(?-i)
  22. (?i)(\d\d\d\d)[-/\s]?((?:Okt.*)|(?:Oct.*))[-/\s]?(\d(?:\d)?)(?-i)
  23. (?i)(\d\d\d\d)[-/\s]?((?:Nop.*)|(?:Nov.*))[-/\s]?(\d(?:\d)?)(?-i)
  24. (?i)(\d\d\d\d)[-/\s]?((?:Des.*)|(?:Dec.*))[-/\s]?(\d(?:\d)?)(?-i)
  25. (?i)(\d(?:\d)?)[-/\s]?(Jan.*)[-/\s]?(\d\d\d\d)(?-i)
  26. (?i)(\d(?:\d)?)[-/\s]?(Jan.*)[-/\s]?(\d\d)(?-i)
  27. (?i)(\d(?:\d)?)[-/\s]?((?:Peb.*)|(?:Feb.*))[-/\s]?(\d\d\d\d)(?-i)
  28. (?i)(\d(?:\d)?)[-/\s]?((?:Peb.*)|(?:Feb.*))[-/\s]?(\d\d)(?-i)
  29. (?i)(\d(?:\d)?)[-/\s]?((?:Mar.*))[-/\s]?(\d\d\d\d)(?-i)
  30. (?i)(\d(?:\d)?)[-/\s]?((?:Mar.*))[-/\s]?(\d\d)(?-i)
  31. (?i)(\d(?:\d)?)[-/\s]?((?:Apr.*))[-/\s]?(\d\d\d\d)(?-i)
  32. (?i)(\d(?:\d)?)[-/\s]?((?:Apr.*))[-/\s]?(\d\d)(?-i)
  33. (?i)(\d(?:\d)?)[-/\s]?((?:Mei.*)|(?:May.*))[-/\s]?(\d\d\d\d)(?-i)
  34. (?i)(\d(?:\d)?)[-/\s]?((?:Mei.*)|(?:May.*))[-/\s]?(\d\d)(?-i)
  35. (?i)(\d(?:\d)?)[-/\s]?((?:Jun.*))[-/\s]?(\d\d\d\d)(?-i)
  36. (?i)(\d(?:\d)?)[-/\s]?((?:Jun.*))[-/\s]?(\d\d)(?-i)
  37. (?i)(\d(?:\d)?)[-/\s]?((?:Jul.*))[-/\s]?(\d\d\d\d)(?-i)
  38. (?i)(\d(?:\d)?)[-/\s]?((?:Jul.*))[-/\s]?(\d\d)(?-i)
  39. (?i)(\d(?:\d)?)[-/\s]?((?:Agu.*)|(?:Ags.*)|(?:Aug.*))[-/\s]?(\d\d\d\d)(?-i)
  40. (?i)(\d(?:\d)?)[-/\s]?((?:Agu.*)|(?:Ags.*)|(?:Aug.*))[-/\s]?(\d\d)(?-i)
  41. (?i)(\d(?:\d)?)[-/\s]?((?:Sep.*))[-/\s]?(\d\d\d\d)(?-i)
  42. (?i)(\d(?:\d)?)[-/\s]?((?:Sep.*))[-/\s]?(\d\d)(?-i)
  43. (?i)(\d(?:\d)?)[-/\s]?((?:Okt.*)|(?:Oct.*))[-/\s]?(\d\d\d\d)(?-i)
  44. (?i)(\d(?:\d)?)[-/\s]?((?:Okt.*)|(?:Oct.*))[-/\s]?(\d\d)(?-i)
  45. (?i)(\d(?:\d)?)[-/\s]?((?:Nop.*)|(?:Nov.*))[-/\s]?(\d\d\d\d)(?-i)
  46. (?i)(\d(?:\d)?)[-/\s]?((?:Nop.*)|(?:Nov.*))[-/\s]?(\d\d)(?-i)
  47. (?i)(\d(?:\d)?)[-/\s]?((?:Des.*)|(?:Dec.*))[-/\s]?(\d\d\d\d)(?-i)
  48. (?i)(\d(?:\d)?)[-/\s]?((?:Des.*)|(?:Dec.*))[-/\s]?(\d\d)(?-i)
  49. (\d\d\d\d)[-/\s]+(\d(?:\d)?)[-/\s]+(\d(?:\d)?)" ,
  50. (\d(?:\d)?)[-/\s]+(\d(?:\d)?)[-/\s]*(\d\d(?:\d\d)?)" ,
  51. (\d\d)(\d\d)(\d\d\d\d)
  52. (\d\d)(\d\d)(\d\d)
  53. (\d\d\d\d)[-/\s]?(\d(?:\d)?)[-/\s]?(\d(?:\d)?)
  54. (\d(?:\d)?)[-/\s]?(\d(?:\d)?)[-/\s]?(\d\d(?:\d\d)?)
Example 1 : Example 2 : Example 3: