ToDateString (DateTimeOffset)
Name | ToDateTimeOffset |
Syntax | ToDateTimeOffset (String dateStr, String format) |
Purpose | To convert a string into a date according to the given format. |
Description | Returns the resulting date time offset. Returns error if date cannot be converted. |
Return Type | DateTimeOffset |
Parameters | dateStr [System.String] – String representing date value to convert. format [System.String] – Date format to use to convert. |
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F0%2520%28113%29.png&width=768&dpr=4&quality=100&sign=c504f191&sv=1)
Example
In this example, we will pass string values to the function transformation object using a Variables object.
Where,
dateStr = 15/13/MAR
format = dd/yy/MMM
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F1%2520%28114%29.png&width=768&dpr=4&quality=100&sign=24ce84bd&sv=1)
In the output window, you can see that the provided dateStr value, of the specified format value, has been converted into a date time offset value.
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F2%2520%28114%29.png&width=768&dpr=4&quality=100&sign=d89646ca&sv=1)