Change time stamp into month

[bharani8]

Hi Experts - I have a time stamp like below.. So now when i click on the Jan month i need the last week of the Jan(1/28) to be selected.. likewise for other months as well.. Plz advice..

1/7/2017 0:00:00

1/14/2017 0:00:00

1/21/2017 0:00:00

1/28/2017 0:00:00

2/4/2017 0:00:00

2/11/2017 0:00:00

2/18/2017 0:00:00

2/25/2017 0:00:00

3/4/2017 0:00:00

3/11/2017 0:00:00

3/17/2017 0:00:00

3/25/2017 0:00:00

4/1/2017 0:00:00

4/8/2017 0:00:00

4/15/2017 0:00:00

4/22/2017 0:00:00

4/30/2017 0:00:00

[ahaahaaha]

Hi,

Try (look attached file)

Month(Timestamp#([Date field], 'MM/DD/YYYY hh:mm:ss'))

Regards,

Andrey

[jmvilaplanap]

Hi

Is a little bit messy, but I think it can works:

WeekStart(MonthStart([Date Field]) -1)

This will return the start of the last week of the month (for each month)

[bharani8]

Anyone have any diff idea to get the necessary output ?

[Anonymous]

The ideas provided look quiet good.

So please explain what doesn't work for you exactly?

[Anonymous]

I think you should rather create three listboxes for users to select their own dates. It gives the user a chance to interact with your model. and these boxes should each consist of one of the following:

Month

Year

Day

In your script you should add these three fields.

month(yourtimestampfield) as Month,

day(yourtimestampfield) as Day,

year(yourtimestampfiled) as Year

Hope this makes sense.

It is just a simpler way...