
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date conversion to Number
I need to convert a date field into Numeric.
Num(Date ( 2014/11/12 , 'YYYYMMDD' ) )
output expecting:20141112
The num function giving me the result but not the way I was expecting.Any help on this would be great.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you really want the *numeric* value to be 20141112, then I think it would be done like this:
=num#(Date(Date#('2014/11/12','YYYY/MM/DD') ,'YYYYMMDD'),'0')
-Rob

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try something like this
Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or maybe even this :
date ( (Date# ( '2014/11/12' , 'YYYY/MM/DD' ), 'YYYYMMDD' )


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
see this:
Num(Date#(Field, 'MM/DD/YYYY')) AS NumericDate
Regards
André Gomes

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try in place of the NUM with Date#
=Date (Date#('2014/11/12' , 'YYYY/MM/DD' ) ,'YYYYMMDD')
Regards
Anand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Date ( Floor(Date# ( '2014/11/12' , 'YYYY/MM/DD' )), 'YYYYMMDD' )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or you can try
=Date(Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) ),'YYYYMMDD')
Regards
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
This should work
=Date(Date#('2014/11/12','YYYY/MM/DD') ,'YYYYMMDD')
Regards
ASHFAQ


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you really want the *numeric* value to be 20141112, then I think it would be done like this:
=num#(Date(Date#('2014/11/12','YYYY/MM/DD') ,'YYYYMMDD'),'0')
-Rob

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Rob.It is always a pleasure to see you here.Yes I wanted to have a numeric value because at the end I am going to comapre this date converted numeric vaule with another Numeric field.Thanks again for your help.

- « Previous Replies
-
- 1
- 2
- Next Replies »