Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Getting firstday of month and last day of month issue

Hi,
I  give "2016-07-14"  as input to get the First day of month and Last day of month. But it is showing 01-01-2016 and 01-31-2016, which is incorrect.
Please find the attached tmap and tlogrow screen shot
I would appreciate your help. 
0683p000009MFSg.png

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi
I tried it on my side. Please refer to screenshot.  Do you think its fine?
Thanks
0683p000009MFNg.jpg

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi
I tried it on my side. Please refer to screenshot.  Do you think its fine?
Thanks
0683p000009MFNg.jpg
Anonymous
Not applicable
Author

Hi,
Thank you. I used MM/dd/yyyy format now and got the result. The MM made the difference.
Anonymous
Not applicable
Author

Thanks for the help!