Date() function

[#1]

Hi, I'm confused about how/when to use this function.  Any tips?

[#2]

You can use Date() any time you need to manipulate a date field format

Date(sale_timestamp,'YYYY-MM') would give you 2013-10

[#3]

If you have a specific question or example you need help with please post it and I would be happy to help if I can

[#4]

Thank you.  So, another option would be Date(sale_timestamp,'MM') to get just the month- is that right?

[#5]

Yes, you can also use Month(sales_timestamp)

[#6]

Date: When you are getting your date data as number then sipmly you can use data function to format.

Date#: When you are getting your date data as string /expression then this function Evaluets the expression and give date based on format provided

[#7]

This is my issue:

Monthly_Exchange_Rates:

Load

Currency,

Date#(Month, 'YYYY-MM') as [Year-Month],

Mid(Month, 6, 2) as MonthNum, /*This worked, but is there another way? Month(Month) just gives a "-" */

Rate

Inline [

Currency, Month, Rate

EUR, 2013-05, 1

EUR, 2013-07, 1

EUR, 2013-06, 1

EUR, 2013-09, 1

EUR, 2013-08, 1

[#8]

I have this:

Date#(Month, 'MM') as MonthNo2

Where the Month field is 'YYYY-MM' format.  I want ONLY  the month part.  But it's not happening.

[#9 · Accepted solution]

You can use like

Date(Date#(Month,'YYYY-MM'),'MM') should give you Month number

[#10]

I appreciate that. Thanks.