This operator is only available when connected to an Aster database.
The To_Date operator converts a String argument to date format. When dragging a To_Date operator into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - String Functions > To_Date
![](data:image/gif;base64,R0lGODlhGQFkAHAAACH/C05FVFNDQVBFMi4wAwEBAAAh+QQBAAD8ACwAAAAAGQFkAIcAAAAAADMAAGYAAJkAAMwAAP8AKwAAKzMAK2YAK5kAK8wAK/8AVQAAVTMAVWYAVZkAVcwAVf8AgAAAgDMAgGYAgJkAgMwAgP8AqgAAqjMAqmYAqpkAqswAqv8A1QAA1TMA1WYA1ZkA1cwA1f8A/wAA/zMA/2YA/5kA/8wA//8zAAAzADMzAGYzAJkzAMwzAP8zKwAzKzMzK2YzK5kzK8wzK/8zVQAzVTMzVWYzVZkzVcwzVf8zgAAzgDMzgGYzgJkzgMwzgP8zqgAzqjMzqmYzqpkzqswzqv8z1QAz1TMz1WYz1Zkz1cwz1f8z/wAz/zMz/2Yz/5kz/8wz//9mAABmADNmAGZmAJlmAMxmAP9mKwBmKzNmK2ZmK5lmK8xmK/9mVQBmVTNmVWZmVZlmVcxmVf9mgABmgDNmgGZmgJlmgMxmgP9mqgBmqjNmqmZmqplmqsxmqv9m1QBm1TNm1WZm1Zlm1cxm1f9m/wBm/zNm/2Zm/5lm/8xm//+ZAACZADOZAGaZAJmZAMyZAP+ZKwCZKzOZK2aZK5mZK8yZK/+ZVQCZVTOZVWaZVZmZVcyZVf+ZgACZgDOZgGaZgJmZgMyZgP+ZqgCZqjOZqmaZqpmZqsyZqv+Z1QCZ1TOZ1WaZ1ZmZ1cyZ1f+Z/wCZ/zOZ/2aZ/5mZ/8yZ///MAADMADPMAGbMAJnMAMzMAP/MKwDMKzPMK2bMK5nMK8zMK//MVQDMVTPMVWbMVZnMVczMVf/MgADMgDPMgGbMgJnMgMzMgP/MqgDMqjPMqmbMqpnMqszMqv/M1QDM1TPM1WbM1ZnM1czM1f/M/wDM/zPM/2bM/5nM/8zM////AAD/ADP/AGb/AJn/AMz/AP//KwD/KzP/K2b/K5n/K8z/K///VQD/VTP/VWb/VZn/Vcz/Vf//gAD/gDP/gGb/gJn/gMz/gP//qgD/qjP/qmb/qpn/qsz/qv//1QD/1TP/1Wb/1Zn/1cz/1f///wD//zP//2b//5n//8z///8AAAAAAAAAAAAAAAAI/wD3CRxIsKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzIsaPHjyBDihxJsqTJkyhTqlzJsqXLlzBjypxJs6bNmzhz6tzJs6fPicqCCh1KtKjRo0iTKl3KtKnTp1CjSp1KtWpUhcp+FsyqlSHXmV+7hjU49mfZrmT3EQu1lhioYm9BtWUbF+5ct3DtsqWbV+5evHGJ7Tvbk7BAw/qqhCKoKE5Cdg8OQiY4+SJiKgAyQxBYWWPnjFlBGdSnKLPpIwYhRxuomuLiy6YBGIGoz8rqfbVvU44MFKvCdagFzssxsTXnB7opIrYtUJeFwvuKJRyeUF4CgtYrCl5+ex5zh7kFhv9HSB2i4cEK53W5XW62xM/ZLSccv2/R4p2hp+dIvlu3cYmicTeQfQ+NR59B+czA30LnnacPgfowEgo7piHHTgMqWKAahZlZ6IAKAFiI3D7BdBiNPpgB4BiD8323Dy13bEgBZhaUKMBqJYYYDTsOaKEjipk51lqOm/HoI3JAquibYOSNcRuHOsqDAIjIxZcjkimueJB0Au4zDws7PvdijD3qOJCBtvEIho6qERJikloi1OBCwHlJHEEwtnPjPp/to0sc8gSwGC1GtBOZPJvts04Q68xWnm8I0QfjZHqe6AdqfyIqEHDsCHDKi3E06qWTk7FznZ9GzBPAp7SE6uidcu7/c99BCR70JzurvlholYkuKmo+TiIU4HwpArCnpn7e0U6uf575XW7yCLBYptfVGsyrLCZ0Hm5dkBhEc6bFOKJ1q+liGqCnIkouLbFpmNkdDXXpJ7rRyPNceMEcwa5pEMjDW6bvCkSuLsGxo+G/cXAI75L6EWTuu/5ydvA+pZnmrpIJbZdQPt8RaLBAk/IGo7O35VZZyNFQp7BXkCpUyymFfBpMoiELZCiJieqi7IgGq0bwQYTs2fJoz1Zxys3sbBaeOXDo4p7ACZSrZdDRGBoNoQL3G/WYA1Gt7T6iIZTgbTM3F0c7W9vr89OMCW3Qay0++Zy9zYkr9ZmMdLdfazpP/zacbl5/LbhC8uAQbJ2k0bsPuYgTIm5zR5S658xO4+ZirJF+p0uRVd7LXDBBdIpjvyPCWDm018VHS+QIn375Vvts0vCmqCUe8Yus8znA6K4vKJDGmZds2zwz4EYFumbjuXDZ5I6p2jxOYn1gWoMTu2KSAOx83InFAsovnyNeaXxmwQ1dEPZiTqZpeKJyGJmpZieJ2pCZPdcajPL7Zlg+64lXbIwWAx+OOjQ+2SRkWMEbCNZKIwAw7Gw1I2MMAfdxszHdDEUCgEaKyoe5DooFLSzSREy4BEL0VE8r20JLVpYREwSq0Hw/YVIJD5IVTfhFE8rYhFx02JbA/MWHgNELDv83oQxNLMOGcBliEVmYQpzI8CBPROEMPRiTJt6kQVbJoha3yMUuevGLYOTiFMdIxjKa8YxoTKMa18jGNrrxjT+ZBBrkOAkxyLERc0QDHumYRz76sY+A/KMgA5nHPdpRj4VM5B0JOcg68nGPjIxkIyU5x0MacpKYpGQmJwlJR2ryk5sE5SE92ck8FgQNMYjBDVSpylW2MpWpdCUrYwlLWdqylrikJSxxucpestKXwPzlLm9JS1++MpezTCYxlbnLYQqzl66Mpi6lOUtqWnOa2GSmMW8gS2bq0pvgXKY4i/nMaxZkEjdIiTLosc52svOd7ownPOcpz3rS8572zCc+4Vj/RlSqM4xWIUYW+UlGdP5ToEFBaFEQytCEOlQZDYWoUBQa0YgahaITfahErUjQnKCBCxhppkhjsBV6CANEmfkBPQTKTmKws50wfalMgzLTmNJUGRWr0EyFIQOIspOnN41pMqoAinZ2dIqTIKlBIokQpTZ1K8oAKkyVotCo9lQYLNCoVhHKzqGC4qUOlWpQxLrRZPhIAEUNylFniIZ0GmQSB4HrQZIpUrcOZKw9dWhLX+qOoK4Ur2kVyjxYqoxk/BWsAk2GFYpK2HXyNK0mlYFcYppYokp0rSVM6kHQsNmnFgQa+wCtUw8T2bQ+VhnsQABP1wQANSgDGShNg49Ue1UQ/wUAFKvNjGsLK9gVpDWnRuCpj24L1JNmBg5C8apRMYuWtsb1uXPdRyYmAY1JZKIe1lXGaAcTVZQGABN55elJkctTs7p2qG64qgw+QQgjKKMWDxivVRP6UmQslijskMFJjUCPRcR3BsnYAnnzSo9k+FYozEWLZpe6j9gAYB+cjTCEBULSsGQlK9sF7E/Dq18E4BW8Nx2GZIUxA6mKl8NFMXBRTYrSBIBXoMhgAXiNm5kAILew94VogruCBjFA95xPnW51M6GM6Wq3IC4lsVBIXFSeZiK8JZasUPJrVUzMoMkyeDKWV0wMw3qVGMiowoBPK94ExHjFNB3Gl+fB0R3HZIbBp+zsXLlSD2jUuR4YhqpYvWpS2uJVGVo4bxXc4GESm1cZu4hvTyOb4vuquM+YYEFRE11eLZD3wIW1rFrd7BN/vvXHBVFqVuixDFJD48gEAWw7F5GZA8jAE1e2KiiSkSI4DIMKAgAvbkFUaCkDlatgvi89amEaBCQDpYW+Mq0BYOPkarrNnP92iUHfigZCIqSb38wwTLlqlJoiBaxISUYX/yqUvka7J54+yVDATVOWVnWqYAX3TF0qFHJr9aX0XrdPg2qUc/Nk2ieht0LF/W5+77vgVB2KOwxb2JZO1d1EGUZC2bzOLkPb3yr56D/Ffdh1cpy3ypA4PSQOcjZD/K+N7avHFxoUcbf8pS6n+FQ3ulyM4wTOG+GszXfuEufy/OdlxLlGdA70opfE5zzZV4UYIg+UYszocBR6RZgKEQpQ4AEUSGBDiLcafRAiTgJTENTPmO6LyLUgkqh6BSpAAbbTygqf2jqs/lYQ4o39jAC/CNEJkga1t73tBxnPPGwb94LIQ+z74Nj/KZQOh9JEbfDMntXdtaLxjJydIGl/CNs3n3UEwR03X9/HLhJVd8TrI2YDIV4yFHT6xXB98l3Ju0U46+B99F3CezfI3zcfeObQPR8yWJA89iOe4bUYH8XLh9MFBXvKb7cilx9I5h3Cebd7/lN291LxDJJ97T9DMXZafcrA1HwQSp0iuRdI3yHC+QQmjkS8KcjYcNOY2nzKVMg/Uei/5Lvy3wTpZncQ06cRiiccILI1BtF05yIQOQIACaBBNwIkzOd/PXF+EyEJaJAGkqCBHEiBHtgQADhF+VAsxtJ/H1hQz3eCKkgSlbeCLkgSsscS6feCO1d2NHiDHBGDKzGDOHhu/zaYRgX4ESOoJfLAAoW3OIiXEaUBdhQRhARlgSnBgxgRDEy4dcHHEMEABAOxC1pIEK9nhSbIMSboEIe3Gn3yRiGIRtPjEF+YHmJ3ekeIhA/RhtyXhBTxevpgCGOYRlCIElJoEX5jW6EwDzLgI0XgJkBAiGdlCo6nCLyhCF1IEK2XeAqidHEwHMlwhYSYMoIoHm6CAJxoLHEHJDcCeZ6iiACAAD7yA4j4IqYBB26yNY3RUT3WRqADh9rnDCtwCvOwAqGQIM+wi6IHAVyXD2AihgeRhaIXid4nA69HPNBQCK53hXYCeo6RaKnHeqGXaPngi73Ii96YhJgIK8r4hCmYcf8ThnsTRhHtAXk1lgkKwnXEU4aJxwLOsH2NkTQSFBlcRyDuiADE8wxid3jKZxoTWIxiN3/7kH+/NwMImTLxuB/umAD0qCjMiIbnWEZcaIy6QR2E6H3bp3piZzAvEymFAI8nAn4JsnqHJxwARn51F3zZ131215JeIgMCKYfzgAM3mRiulwOrt4Uc9EY6iI4egShe5xhfkonRMDYJUoSfMnr5l3hUgIDJGAOzgYymMnzQ8HmQAQ37B5Nj837BEH/AtxqzODObODYI+QxemQBTCSq0mJFklBsS+IvxqCCH9wwxcIDGsyeKwDbc54sCsQsVEpQ5cgDFc5cDMYKleIAdKXaOkBc1tbKJ8lg8DfiAuHYKeRiHbtSHJ/GHFkGFW7d9RLOHJYQsBJWGaOSE+rEgFCKYZoSMHQWaJiGaPZhgtZibvGl2dBmavWlzPxicxMkQRRmFxemDvzlGrtkR7ggAFwkTzelmtnl0ILELVch0dkge23mH3Rl2ulGRCnGGO8aaZrSGpYmaw6cR4ll6qDkaev/ob9XJgh8RiJGHiqwInfJQiMZiCm7yAI4oEJBYhx0JIqfIn6oIAIcInRTzio6nG4YJnaVhbPyZAAJZMUrZYqsBCdmJWbu5RreIesSji+DIizMQjFEJAWwJJmvojhm0jQ/QjSXai4NIfC4ZlI05PCwQlDI6jyqglDMAlkBamLKZYPM5EuqojuyYKsuHkgj5esaIDNvHoZ/BLjGKeA15mRAJkV6CUg9Ad13DoAyplyc6kDlAd8O3GuUQnbq5nDO0kTCpfTd5kzkJkmb4ALsgedmYjatBiDnZkjuZMjgADeBHPFK6ILQgAOL3kcTzjDMgpS6JI99ybsdJRkgZls8QfGyw6ZBGCH+baDxWSRBxSZb9EpFcGpDMYSoK6SUrcAen9wkK4pQnKgMCMTazOH+t4m/DOZu2cZdaupPJ0JcO+JdoWaTaV6DDypYyKZHFE6Eh8gy4phs5YgQYxJSEKH462WK4YQieaaRuOkOkyRC10nvvSRMRo5rRZp7n+XkL8akFEZs+MYI1Fgr2h3FHmpzE+aH4uq9x9a382pu7+q/4WqkCm6/+WrA4eK8IS4PqurA3GBAAOw==)