Crystal Reports Year to date of epoch time

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Year to date of epoch time

Author	Message
elie234 Groupie Joined: 21 Aug 2009 Online Status: Offline Posts: 68	Topic: Year to date of epoch time Posted: 25 Aug 2009 at 1:45pm
	I am doing a report where I would like to select records year to date. My difficulty is that the date field is in epoch time from 1/1/1990. What would be the formula for this record selection? I know I could use yeartodate and dateadd but am having trouble pinning it down. Thank you.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 25 Aug 2009 at 3:43pm
	I think this will work but can not test it right noiw... DateAdd("s", EpochDate, datetime(1990,01,01)) in YearToDate
	IP Logged

elie234 Groupie Joined: 21 Aug 2009 Online Status: Offline Posts: 68	Posted: 25 Aug 2009 at 3:48pm
	*Originally posted by DBlank* I think this will work but can not test it right noiw... DateAdd("s", EpochDate, datetime(1990,01,01)) in YearToDate Thanks!
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.