Pull Year from a Date

[fanninam]

I'm trying to pull only the year from this date.  The date format is:  01/01/1947 0:00:00

What code statement would I use to pull only the year?

[Frank_Hartmann]

try like that

year(Date('01/01/1947 0:00:00','MM/DD/YYYY h:mm:ss')) or

year(Date(YourDatefield,'MM/DD/YYYY h:mm:ss'))

hope this helps

[juan_patrick]

Hi Amber,

Year function:

year ‒ QlikView

¡Good luck!

[Anil_Babu_Samineni]

How about this?

Load ..., Year(Date) as Year from Table where Year(Date) = 1947;

[fanninam]

I've tried all of these below and it's not pulling anything.  I'm getting confused.

[fanninam]

Could it be the AM that is throwing it off?  If so, how would I include the AM portion to the code statement?

1/14/1953  12:00:00 AM

[Anil_Babu_Samineni]

You can define it as tt for AM and TT for PM ??

[Frank_Hartmann]

can u prepare and upload a sample qvw including your date field?

[juan_patrick]

Try this:

year(floor(YourDatefield))

[juan_patrick]

Another thing,

Where are you doing this? in the load where you connecto to the DB? If yes, do it from a resident table!