Mixing
Date Formatting In Google Data Studio
So I have got a date field in my data warehouse and its format is:
Feb 15, 2018
And With Calculated field with the following formula;
TODATE(Date, 'DEFAULT_DASH', '%m')
I am getting output = February, all good till this moment.
But when I am trying to add the year, strange things start to happen. For this formula:
TODATE(Date, 'DEFAULT_DASH', '%Y-%m')
The output is;
Jan 31, 2018
so it is wrong month.
I am getting same results with DEFAULT_DECIMAL
google-data-studio
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
add a comment |
So I have got a date field in my data warehouse and its format is:
Feb 15, 2018
And With Calculated field with the following formula;
TODATE(Date, 'DEFAULT_DASH', '%m')
I am getting output = February, all good till this moment.
But when I am trying to add the year, strange things start to happen. For this formula:
TODATE(Date, 'DEFAULT_DASH', '%Y-%m')
The output is;
Jan 31, 2018
so it is wrong month.
I am getting same results with DEFAULT_DECIMAL
google-data-studio
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
If you make a table withDateand the calculated field as the columns, what does theDatedimension look like?
– diminishedprime
Nov 20 '18 at 21:19
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37
add a comment |
So I have got a date field in my data warehouse and its format is:
Feb 15, 2018
And With Calculated field with the following formula;
TODATE(Date, 'DEFAULT_DASH', '%m')
I am getting output = February, all good till this moment.
But when I am trying to add the year, strange things start to happen. For this formula:
TODATE(Date, 'DEFAULT_DASH', '%Y-%m')
The output is;
Jan 31, 2018
so it is wrong month.
I am getting same results with DEFAULT_DECIMAL
google-data-studio
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
So I have got a date field in my data warehouse and its format is:
Feb 15, 2018
And With Calculated field with the following formula;
TODATE(Date, 'DEFAULT_DASH', '%m')
I am getting output = February, all good till this moment.
But when I am trying to add the year, strange things start to happen. For this formula:
TODATE(Date, 'DEFAULT_DASH', '%Y-%m')
The output is;
Jan 31, 2018
so it is wrong month.
I am getting same results with DEFAULT_DECIMAL
google-data-studio
google-data-studio
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
asked Nov 20 '18 at 20:31
marekparsnipmarekparsnip
83
83
If you make a table withDateand the calculated field as the columns, what does theDatedimension look like?
– diminishedprime
Nov 20 '18 at 21:19
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37
add a comment |
If you make a table withDateand the calculated field as the columns, what does theDatedimension look like?
– diminishedprime
Nov 20 '18 at 21:19
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37
If you make a table with
Date and the calculated field as the columns, what does the Date dimension look like?– diminishedprime
Nov 20 '18 at 21:19
If you make a table with
Date and the calculated field as the columns, what does the Date dimension look like?– diminishedprime
Nov 20 '18 at 21:19
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53401056%2fdate-formatting-in-google-data-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53401056%2fdate-formatting-in-google-data-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you make a table with
Dateand the calculated field as the columns, what does theDatedimension look like?– diminishedprime
Nov 20 '18 at 21:19
Hi there, So the date looks like this in the table: Feb 15, 2018 but the new calculated field is showing this Jan 31, 2018
– marekparsnip
Nov 21 '18 at 9:29
Looks like a bug. It brings back the end date of the previous month regardless of the day of month. You should report it here issuetracker.google.com/savedsearches/578413
– Bobbylank
Nov 22 '18 at 14:37