Converting string date
Joined: 08 Dec 2011
Topic: Converting string date
Posted: 31 May 2012 at 10:15am
Question: I need help formatting a date in string format to date-time format in the Data Architect. How is this accomplished?
Answer: This can be accomplished by using a combination of accepted formats and an available function within the Data Architect.
1. The supported date time formats are the following: datePartForMat timePartForMat
An option would be to use a “Convert to Date” function block inside the DAX (from All Functions – Conversion – to datetime).
This function block has 2 input parameters:
· Input – you can use a constant of type “string” as input and pass the value from your application in the desired format
· Format – here you can use a constant string for formatting purposes. Note that the format string and the input string must match
See the sample diagram below.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum